Re: Trace file does not list detailed timings

Some platforms require that you set statistics_level=all in order to get the timings - and also plan details in v$plan_statistics. I have not done any measurements, but I believe it is not recommended to set that system wide, only temporarily on a session basis. Since you likely do not have trace enabled system wide either you can just set it in the session when you enable sql_trace. The only problem is that you can enable tracing for a session from a different session, but you can not change statistics_level for a different session. At least I do not know of a way. There are set_int_paramt_in_session and set_bool_param_in_session, but no set_char_param_in_session.

At 03:31 PM 1/27/2006, Jill.Drocea_at_VerizonWireless.com wrote:

>My trace file does not contain details...i.e.
>
>TABLE ACCESS BY INDEX ROWID OTAPA_REQUEST_QUEUE (cr=2 pr=0 pw=0 time=91 us)
>
>Instead shows
>
>TABLE ACCESS BY INDEX ROWID OTAPA_REQUEST_QUEUE
>
>What am I missing?

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l