RE: I/O
- From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Sep 2004 20:28:21 +1000
Hello Seema,
Look in V$SQLAREA for SQL statements with a high number of DISK_READS. =
Examine the execution plans for these statements and consider
whether they can be tuned to reduce the number of block gets.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: Wednesday, 15 September 2004 1:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: IO
I have been experiencing high IO on solaris 5.7 box.
All the database files are on one disk due to disk constraints?
Any idea how to reduce I/O rate?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
