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);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/543979/viewspace-374608/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/543979/viewspace-374608/