Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Designing indexes
News wrote:
> hpuxrac a écrit :
>
> > With so many tables in your environment, you need to prioritize somehow
> > and start drilling into "only" the jobs/batch processes/extraction and
> > load that are important enough to spend time and money improving.
>
> I have traced all ETL sessions and got 5226 trc files. Now I want to
> identify consuming ones knowing by experience that a small number of
> queries consume most of resources. I need help with interpreting tkprof
> output to extract trc files/sessions/queries that need to be tuned from
> information below ?
I still recommend Cary's book before you go further.
Chapter 8 has some sections on how to find inefficient SQL that's a possible starting point but I advise reading the book from the beginning to the end. Received on Fri Feb 10 2006 - 14:52:12 CST