select o.OBJECT_TYPE, substr(o.OBJECT_NAME,1,10) objname , b.objd , b.status, count(b.objd)
from v$bh b, dba_objects o
where b.objd = o.data_object_id and o.owner = '&1' group by o.object_type, o.object_name,b.objd, b.status ;
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
http://www.cndba.cn/dave/article/1776
版权声明：本文为博主原创文章，未经博主允许不得转载。
CNDBA社区
