Typically this event occurs if application is doing frequently large sorts and your sort_area_size or pga_aggreagate_target is small.

For finding which object DB is waiting for , find p1 and p2 from v$session_wait and run the following SQL.

select segment_name,segment_type,partition_name
from dba_extents
where
file_id=&p1_value
and
&p2_value between block_id and (block_id+blocks-1);

direct path read wait event 的處理辦法

相關文章