If the tables have chained rows, Oracle will have to perform additional reads.

If the tables have a lot of blocks with less number of rows (caused due to deletes, and inserts
with direct loads, for example), then it will affect FTS as Oracle will have to perform more
reads.

- Kirti

--- "Kevin P. Balfe" <[Email Address Removed] wrote:
> 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] >To: "LazyDBA.com Discussion" <[Email Address Removed] >Subject: 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
Oracle LazyDBA home page