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: TKPROF: Long CPU time on Execute

Re: TKPROF: Long CPU time on Execute

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 20 Apr 2004 12:22:32 +0000 (UTC)
Message-ID: <c634m8$7nn$1@sparta.btinternet.com>

Error correction in-line

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland  http://www.index.is/oracleday.php
June  2004      UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:c61pjh$f05$1_at_hercules.btinternet.com...

>
> You won't see any library cache misses recorded
> in the trace or tkprof output for this - it's only in
> 10g (I think) that you get lines like:
>
> Misses in library cache during parse: NN
>
That should have read: Misses in library cache during EXECUTE: NN The capture of misses in parses has been around for years.
Received on Tue Apr 20 2004 - 07:22:32 CDT

Original text of this message

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