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
-- //www.freelists.org/webpage/oracle-l