scattered reads

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Tue, 3 Feb 2004 01:28:03 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C01F97936@uswaumsx14medge.med.ge.com>

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_at_med.ge.com 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 03 2004 - 01:28:03 CST