博客首页 注册 建议与交流 排行榜 加入友情链接
推荐 投诉 搜索: 帮助

苦丁茶

tomcent.cublog.cn
热点块tch x$bh

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
        /

发表于: 2008-02-23,修改于: 2008-02-23 17:52,已浏览232次,有评论0条 推荐 投诉

给我留言
版权所有 ChinaUnix.net 页面生成时间:0.00881