capturing the time taken for a query to complete .
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   chandrashekar_jayaraman
Posted On:   Tuesday, December 5, 2006 12:18 AM

hey,

How is it possible to capture the time taken for a query or a proedure to execute in oracle using jsp.
thanks.

Re: capturing the time taken for a query to complete .

Posted By:   WarnerJan_Veldhuis  
Posted On:   Tuesday, December 5, 2006 01:43 AM

Either start profiling on Oracle, or time it in your code:

long start = System.currentTimeMillis();
//query stuff here
long end = System.currentTimeMillis();
long durationInSeconds = (end - start) / 1000;
About | Sitemap | Contact