where is the hot ?

SELECT   *
  FROM   (  SELECT   addr,
                     ts#,
                     file#,
                     dbarfil,
                     dbablk,
                     tch
              FROM   x$bh
          ORDER BY   tch DESC)
 WHERE   ROWNUM < 11;
 
SELECT   e.owner, e.segment_name, e.segment_type
  FROM   dba_extents e, (SELECT   *
                           FROM   (  SELECT   addr,
                                              ts#,
                                              file#,
                                              dbarfil,
                                              dbablk,
                                              tch
                                       FROM   x$bh
                                   ORDER BY   tch DESC)
                          WHERE   ROWNUM < 11) b
 WHERE       e.relative_fno = b.dbarfil
         AND e.block_id <= b.dbablk
         AND e.block_id + e.blocks > b.dbablk;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16348200/viewspace-624837/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16348200/viewspace-624837/