MY COMPASS

WITH    DBA_WITH_SNAPSHOT AS     (         SELECT  MIN(SNAP_ID) AS BEGIN_SNAP_ID, MAX(SNAP_ID) AS END_SNAP_ID         FROM    DBA_HIST_SNAPSHOT         WHERE   INSTANCE_NUMBER = 1         AND     END_INTERVAL_TIME   >= TO_DATE('2016/01/18 09:00:00', 'YYYY/MM/DD HH24:MI:SS')         AND     BEGIN_INTERVAL_TIME <= TO_DATE('2016/01/18 10:00:00', 'YYYY/MM/DD HH24:MI:SS')        )       ,  DBA_WITH_SQLSTAT AS     (         SELECT  /*+ INLINE PARALLEL(4) */                 A.*         FROM    DBA_HIST_SQLSTAT    A               , DBA_WITH_SNAPSHOT   X         WHERE   1 = 1     ...

/*  **  특정 모듈에서 수행된 Top SQL 추출하기  */  WITH    DBA_WITH_SNAPSHOT  AS     (          SELECT  MIN(SNAP_ID) AS BEGIN_SNAP_ID, MAX(SNAP_ID) AS END_SNAP_ID          FROM    DBA_HIST_SNAPSHOT          WHERE   INSTANCE_NUMBER = 1          AND     END_INTERVAL_TIME   >= TO_DATE('2016/01/06 16:00:00', 'YYYY/MM/DD HH24:MI:SS')          AND     BEGIN_INTERVAL_TIME <= TO_DATE('2016/01/06 17:00:00', 'YYYY/MM/DD HH24:MI:SS')         )        ,  DBA_WITH_SQLSTAT  AS     (          SELECT  /*+ INLINE PARALLEL(4) */                  A.*          FROM    DBA_HIST_SQLSTAT    A    ...