Re: Chache??

Hi.
Thanks again for your time. But...?

Richard Foote wrote:

> Hi Marc,
>
> Do you use the explain option with TKPROF ? If so, what do the execution
> plans tell you ?
> > No. How would i do that?

> When you say you execute the same cursor, are you using bind variables or
> are they identical hard coded values ?
> > Identical Hard code Values

> When you say the I/O numbers go up, is the cumulatively or individually ?
> > Individually

> *How* Oracle determines the execution plan is dependent on which optimizer
> you use. Cost Based uses statistics on the tables (if they're there) to
> determine the "cheapest" option and not so much on how you write your
> statement per se.
>
> For your question to be appropriately answered you need to provide some more
> details. Version of database, platform, optimizer mode, list of execution
> plans, table statistics, available indexes etc.

> >Oracle 9.2. Platform: Windows2000. Optimizer mode = Choose. List of execution
> plan made with autotrace??, normal table, 3 collumns (prKey int, Str char(30),
> bVar smallint) index on prKey, There is 100.000 unique rows in this table.

> >
> To answer your question 'What does Oracle do ?' requires these details.
>
> But for me it's bedtime, although if you post these details I'm sure some
> else will be able to assist.
>
> Good Night
>
> Richard
> Thanks again.

Marc Received on Thu Sep 26 2002 - 09:44:38 CDT