Re: scattered reads
- From: Jerome Roa <jroa@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 Feb 2004 09:29:02 -0600
Dave,
I'm back-I'm free this afternoon or tomorrow afternoon.
J
At 07:42 PM 2/3/2004 +0200, you wrote:
>Maybe you have analyzed your data dictionary by accident (or haven't set
>optimizer* parameters accordingly) and your query uses full table scans on
>underlying tables extensively.
>
>Btw, select * from dba_segments in a fully LMT 9i requires multiple IOs for
>each segment header blocks as well, in order to determine number of blocks &
>extents in it (seg$ contains obsolete information)
>
>Tanel.
>
>----- Original Message -----
>From: "Kommareddy, Srinivas (MED, Wissen Infotech)"
><Srinivas.Kommareddy@xxxxxxxxxx>
>To: <oracle-l@xxxxxxxxxxxxx>
>Sent: Tuesday, February 03, 2004 9:28 AM
>Subject: scattered reads
>
>
> > Hi Gurus,
> >
> > DB: 9.2x
> > OS: solaris 2.8
> >
> > Why the following query is waiting for db file scattered reads....
> >
> > select segment_name from dba_segments
> > where tablespace_name in
> > ('ASPD',
> > 'CSED',
> > 'CUED',
> > 'DDDD' ..... 50 more tablespaces.
> >
> > What could be done to avoid this db file scattered reads ?
> >
> > Is there a better way to get this.
> >
> >
> > Thanks and Regards,
> > Srinivas
> > Oracle DBA ( ODC )
> > Wissen Infotech Pvt. Ltd.
> > Hyderabad, India
> > Work +91-40-55313031, 91-40-27892897
> > e-mail Srinivas.Kommareddy@xxxxxxxxxx
> > Visit us http://www.wisseninfotech.com <http://www.wisseninfotech.com>
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
