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: help with reading tkprof output

Re: help with reading tkprof output

From: sriram717 <sriram.vrinda_at_googlemail.com>
Date: Thu, 15 Nov 2007 07:06:55 -0800 (PST)
Message-ID: <862c50a2-957a-4b0d-995e-17262d527be0@a28g2000hsc.googlegroups.com>


On Nov 15, 3:02 pm, bugbear <bugbear_at_trim_papermule.co.uk_trim> wrote:
> sriram717 wrote:
>
> > This is where the raw sql trace file would give more clarity in terms
> > of where more time is spend.
>
> There will be a short delay; moving the query
> to a test harness, where I can such a trace,
> resulted in the query running delightfully quickly,
> which is gratifying, but not helpful...
>
> BugBear

How about active session history , when the query is run ? , can you take some samples and come up with some thing?

Thanks Received on Thu Nov 15 2007 - 09:06:55 CST

Original text of this message

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