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博客 ” ，链接：https://blog.itpub.net/543979/viewspace-374608/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
CRSCTL和SRVCTL的命令用法
下一篇：
latch free 等待事件的诊断语句
请登录后发表评论
登录
全部评论
