Hi I'm afraid if you are unable to post the query (and preferably the other
info I asked for as well) then no-one in this group can possibly help you.
--
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:1007390642.655129_at_proxy.storm.co.za...
> 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 Tue Dec 04 2001 - 03:11:05 CST
