Re: Help with interpreting TKPROF output

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 1 Sep 2003 01:52:41 -0700
Message-ID: <725736ef.0309010052.33798ad3@posting.google.com>

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0308291153.33eb8e56_at_posting.google.com>...

> Hi, Tim,
>
> The disk column gives the number of blocks physically read (physical
> as far as Oracle sees it; could be cached by the filesystem), not the
> number of disk reads, although the difference is only meaningful in
> case of db block multiblock reading (see
> http://www.stormloader.com/yonghuang/computer/diskreadunit.txt).
> I won't conclude but I think the buffer reads ("query" and "current"
> columns) use the unit of number of buffers, not number of times of
> reading buffers.
>
> To answer your second question, even a query needs current mode gets,
> because the recursive SQLs read the data dictionary.
>
> Yong Huang

Hi Yong,

Thank you very much for the help. I had overlooked recursive SQL!

Best regards,

Tim Kearsley Received on Mon Sep 01 2003 - 03:52:41 CDT