Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Designing indexes
"News" <Contact_404_at_hotmail.com> wrote in message news:1139564346.347298.59060_at_g44g2000cwa.googlegroups.com... hpuxrac a écrit :
....
I have traced all ETL sessions and got 5226 trc files.
...
have you thought of just capturing poorly performing SQL statements from the V$ tables (ie, v$sqlarea)?
identify statements that have excessive block counts (disk_reads+buffer_gets) and start tuning with those.
++ mcs Received on Fri Feb 10 2006 - 04:18:59 CST