sql语句

热点对象

SELECT *
FROM   (SELECT o.owner,
               o.object_name,
               o.subobject_name,
               bh.tch,
               bh.obj,
               bh.file#,
               bh.dbablk,
               bh.class,
               bh.state
        FROM   X$bh bh,
               dba_objects o
        WHERE  o.data_object_id = bh.obj
        AND    hladdr =‘07000001CBD38A30‘
        ORDER BY tch DESC)
WHERE  rownum < 11;

select distinct hladdr from x$bh;