How could I know the duration a single SQL statement takes.
Is there any column in V$SQLAREA shows the time?
Printable View
How could I know the duration a single SQL statement takes.
Is there any column in V$SQLAREA shows the time?
Hi
Use package DMS_UTILITY.get_time()
start := DMS_UTILITY.get_time();
select .....
stop := DMS_UTILITY.get_time();
Quote:
Originally posted by Queyon
How could I know the duration a single SQL statement takes.
Is there any column in V$SQLAREA shows the time?
in 8.1.6 >
use v$session_longops
You can have a Timing on That gives yo the Time in Miliseconds.
SQL> Set Timing on
Select Count(*) From Emp;
Real: 145
Thanks