Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Designing indexes

Re: Designing indexes

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 10 Feb 2006 12:52:12 -0800
Message-ID: <1139604732.577718.99760@g44g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US