scattered reads
- From: "Kommareddy, Srinivas (MED, Wissen Infotech)" <Srinivas.Kommareddy@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 Feb 2004 01:28:03 -0600
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
-----------------------------------------------------------------
Other related posts:
