Re: Estimate I/O cost

From: Yannis Markakis <yannis_removethis_markakis_at_yahoo.com>
Date: Tue, 29 May 2001 02:02:50 +0300
Message-ID: <9eulep$qqi$1@usenet.otenet.gr>

try the tk_prof built in facility of Oracle.

"Marco Poetke" <poetke_at_dbs.informatik.uni-muenchen.de> wrote in message news:3B0E7B1A.2BDA6A16_at_dbs.informatik.uni-muenchen.de...
> Hi!
>
> Is there a way to get the I/O cost estimated by the
> built-in optimizer?
>
> Unfortunately, the measure of 'COST' in the PLAN_TABLE
> is undefined (according to the doc). The 'BYTES'
> attribute seems to correspond to the output size, but
> not the amounts of data touched during the query.
>
> Thank you very much!!
>
>
> Marco.
Received on Mon May 28 2001 - 18:02:50 CDT