Need to know more about your situation. Oracle is not finding the data in
the buffer cache. The first time you run ANY query (after database startup)
it's gotta read the data from the file.


>From: Raj Sharma <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] High Physical reads
>Date: Mon, 30 Jun 2003 08:46:43 -0700 (PDT)
>
>Hi Guys,
>
>Could tables and tablespace fragmentation cause high number of physical
>reads? I am getting very high number of physical reads for simple queries
>also.
>
>Thanks for your help.
>Raj
>
>
>
>---------------------------------
>Do you Yahoo!?
>SBC Yahoo! DSL - Now only $29.95 per month!

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Oracle LazyDBA home page