-
How could I know the duration a single SQL statement takes.
Is there any column in V$SQLAREA shows the time?
Queyon Zeng
-
Hi
Use package DMS_UTILITY.get_time()
start := DMS_UTILITY.get_time();
select .....
stop := DMS_UTILITY.get_time();
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|