Re: Trace file does not list detailed timings

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Jill.Drocea@xxxxxxxxxxxxxxxxxxx
  • Date: Fri, 27 Jan 2006 17:02:26 -0700

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@xxxxxxxxxxxxxxxxxxx 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


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


Other related posts: