Re: View performance tuning

Do the following and paste the output in here:

ALTER SESSION SET events '10046 trace name context forever, level 12'; select * from PERF_VIEW2;

Then run:

tkprof <trace_file> <output>

Where:
<trace_file> - you can find in "udump" directory
<output> - give it a name --> copy the whole content of this file into
this thread. Received on Mon Feb 27 2006 - 06:42:13 CST