Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Driving Table in the execution plan
hi,
To do a better tuning, use either utlbstat and utlestat or use statspack for Oracle 8i and get the report.txt and feed it into www.oraperf.com. It formats the report.txt nicely for you
Tkprof is a good way also but then you have to sift thru a lot of info.
Allan W. Tham
DBA
Received on Thu Sep 06 2001 - 02:02:41 CDT