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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: TKPROF question

Re: TKPROF question

From: Kevin Tsay <ktsay2000_at_comcast.net>
Date: Tue, 23 Mar 2004 16:48:40 -0800
Message-ID: <00fd01c41139$c39e0e20$4bf011ac@corp.sitesmith.com>


It's http://www.juliandyke.com/

--Kevin

> Hi,
>
> Can you give me the URL for the website(Instructions how to dump blocks
are on Julian Dyke's site).
>
> Thanks
> Muqthar
>
> -----Original Message-----
> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> Sent: Tuesday, March 23, 2004 12:38 PM
> To: oracle-l_at_freelists.org
> Cc: Oracle List (E-mail)
> Subject: Re: TKPROF question
>
>
> Dump it. Instructions how to dump blocks are on Julian Dyke's site. It
should be clearly visible
> whch data blocks are data blocks and which are not.
>
> On 03/23/2004 11:16:39 AM, "Jamadagni, Rajendra" wrote:
> > Never mind ... found it now I have to find out why the he11 it waited
that long on one block .... and this block is from one index. now how do I find what type of block is this? branch? data?
> >
> > Why would there be a cr wait of 3288.24 (seconds?/cent-seconds?) if so,
it doesn't match with the summary ...
> >
> > OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
> >
> > call count cpu elapsed disk query current
rows
>


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 23 2004 - 19:28:06 CST

Original text of this message

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