RE: I/O

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 15 Sep 2004 20:28:21 +1000
Message-ID: <001001c49b0e$b93da990$ae8735cb@ixora.com.au>

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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh Sent: Wednesday, 15 September 2004 1:54 AM To: oracle-l_at_freelists.org
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?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 15 2004 - 05:24:39 CDT