Re: Designing indexes

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 10 Feb 2006 05:18:59 -0500
Message-ID: <I86dncay69oI9XHeRVn-ow@comcast.com>

"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