Re: Tkprof - Analyse

Hi patil
check out the SQL's fired and their explain plans and
the time each SQL has taken individually and then try
to reduce them depending upon the situation. enable
tracing while submitting the concurrent request. and
then tkprof the output. 
analyze the report and then tune it. 

regards
Naveen samala


--- Naveen Patil <naveenspatil@xxxxxxxxxxx> wrote:

> Hi All,
> 
> Can anyone please explain how do we analyse the
> tkprof out when we have to tune a Concurrent program
> and how do we tune it...one aspect i did is checking
> the hit ratio is there something else which has to
> be considered.
> 
> 
>  
> Regards,
> N P
> 
> 
>      
>
____________________________________________________________________________________
> Never miss a thing.  Make Yahoo your home page. 
> http://www.yahoo.com/r/hs



      
____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Other related posts: