Managing Blocks in the Buffer Cache
1.sql
find the five "currently hottest blocks" and join that information to the DBA_OBJECTS view to see what segments they belong to.
2.sql
find the five "currently hottest blocks" and join that information to the DBA_OBJECTS view to see what segments they belong to.
点击(此处)折叠或打开
-
select tch, file#, dbablk,
-
case when obj = 4294967295
-
then 'rbs/compat segment'
-
else (select max( '('||object_type||') ' ||
-
owner || '.' || object_name ) ||
-
decode( count(*), 1, '', ' maybe!' )
-
from dba_objects
-
where data_object_id = X.OBJ )
-
end what
-
from (
-
select tch, file#, dbablk, obj
-
from x$bh
-
where state <> 0
-
order by tch desc
-
) x
- where rownum <= 5
点击(此处)折叠或打开
-
select tch, file#, dbablk, DUMMY
-
from x$bh, (select dummy from dual)
-
where obj = (select data_object_id
-
from dba_objects
-
where object_name = 'DUAL'
- and data_object_id is not null)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31349667/viewspace-2124548/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
