-
Dear DBA's
Please help me to get timings after SET TIMING ON. In svrmgrl we get timings like
Parse 0.01 (Elapsed) 0.00 (CPU)
Execute/Fetch 0.04 (Elapsed) 0.00 (CPU)
Total 0.05 0.00
But In Sql*Plus If I set timing on then I get real: 10485 . Is it possible to get timings like SVRMGRL.
Thanks & Regards
Shailesh
-
svrmgrl connect to your operating system (and gets some informations there) but sql-plus not. You can "set time on" and get the time every statment or "set timing on" for the elapsed time.
-
[QUOTE][i]Originally posted by aracnid [/i]
[B]svrmgrl connect to your operating system (and gets some informations there) but sql-plus not. You can "set time on" and get the time every statment or "set timing on" for the elapsed time. [/B][/QUOTE]
Thanks Aracnid, But Here I wanted not just time, I want them seprately for Parse, Fetch/execute etc. Is it Possible.
Regards
Shailesh
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
|