Re: KEEP pool and disk reads
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 26 Jun 2004 00:22:52 -0400
On 06/26/2004 12:00:03 AM, Rajesh.Rao@xxxxxxxxxxxx wrote:
> Now, how do I verify where the disk reads are coming from?
The event is 10046, level 10. Your physical reads are not caused by sort,
because statistics says that it was in-memory sort, which means that
it was quicksort in memory. You can turn 10046 on by using DBMS_SUPPORT
or DBMS_MONITOR. The event 10046 will show you what are you waiting for.
If you are waiting on event like db_block_sequential read, or
db_block_scattered_read, it is possible that you are waiting on disk I/O.
These wait events have arguments which will give you block which oracle
is waiting for. That should tell you where the blocks are and what are you
waiting for. My guess is, since you say that everything is in the SGA,
that you are waiting for the UNDO block.
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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:
