Re: TUNING DBA

I can't send the query!
When i do the query for the first step, the time is long, but i repeat the query the time is short!
Is there a parameter for the to large the cache o for the phisically read???
The version is 8i.

Niall Litchfield wrote:

> can you post the query - the explain plan and any relevant indexes. Version
> would be nice as well

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer

> ******************************************
> "rericcardo" <riccardo.re_at_kmatrix.it> wrote in message
> news:1007387150.420882_at_proxy.storm.co.za...
> > Hi. Sorry for my bad English... I have a very hard problem!!! The query in
> > my pck generate hight phisical read! Why???? I use bind variable. HELP
> > ME!!!!
> > Rex
> >
> >
> > Posted via www.orafocus.com - Focusing on the World of Oracle
> >

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Mon Dec 03 2001 - 08:46:28 CST