Re: KEEP pool and disk reads

On 06/26/2004 12:00:03 AM, Rajesh.Rao_at_jpmchase.com 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_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
-----------------------------------------------------------------