Re: TUNING DBA "phisical read"

From: Stefan Roesch <sroesch3_at_attbi.com>
Date: Tue, 04 Dec 2001 07:52:53 GMT
Message-ID: <ph%O7.3832$R84.24926@rwcrnsc52>

Hi riccardo,

there is a misconception: Bind variables and physical reads have no direct relation. To check for the high number of disk reads you have to look at your sql statements. Are all the necessary indexes in place? It seems to me your doing full table scans. You also mention that the second time the query runs faster. This seems to to verify this assumption. Do a explain on the corresponding statements and look for full table scans

Hope this helps
Stefan

rericcardo wrote:

> 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
Received on Tue Dec 04 2001 - 01:52:53 CST