Sql*Plus Timing

[shailesh]

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

[aracnid]

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.

[shailesh]

[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