Admin 2. 09장 Automatic Performance Management

AWR

 

S SYS> desc dba_hist_snapshot
 Name                                                        Null?    Type
 ----------------------------------------------------------- -------- ----------------------------------------
 SNAP_ID                                                     NOT NULL NUMBER
 DBID                                                        NOT NULL NUMBER
 INSTANCE_NUMBER                                             NOT NULL NUMBER
 STARTUP_TIME                                                NOT NULL TIMESTAMP(3)
 BEGIN_INTERVAL_TIME                                         NOT NULL TIMESTAMP(3)
 END_INTERVAL_TIME                                           NOT NULL TIMESTAMP(3)
 FLUSH_ELAPSED                                                        INTERVAL DAY(5) TO SECOND(1)
 SNAP_LEVEL                                                           NUMBER
 ERROR_COUNT                                                          NUMBER
 

 

 

S SYS> select SNAP_ID,STARTUP_TIME from dba_hist_snapshot order by SNAP_ID;

   SNAP_ID STARTUP_TIME
---------- ------------------------------------------------------------------------                                                                                              ---
        63 03-JUN-09 04.15.34.000 PM
        64 03-JUN-09 04.15.34.000 PM
        95 18-JUN-09 01.37.45.000 PM
        96 18-JUN-09 01.37.45.000 PM
        97 18-JUN-09 01.37.45.000 PM
        98 18-JUN-09 01.37.45.000 PM
        99 18-JUN-09 01.37.45.000 PM
       100 18-JUN-09 01.37.45.000 PM
       101 18-JUN-09 01.37.45.000 PM
       102 19-JUN-09 04.23.05.000 PM
       103 19-JUN-09 04.23.05.000 PM
       104 22-JUN-09 03.09.26.000 PM
       105 22-JUN-09 03.55.02.000 PM
       106 22-JUN-09 04.31.41.000 PM
       107 22-JUN-09 04.31.41.000 PM
       108 23-JUN-09 02.36.02.000 PM
       109 23-JUN-09 02.36.02.000 PM
       110 23-JUN-09 02.36.02.000 PM
       111 23-JUN-09 02.36.02.000 PM
       112 24-JUN-09 02.17.55.000 PM
       113 24-JUN-09 02.17.55.000 PM
       114 24-JUN-09 02.17.55.000 PM
       115 24-JUN-09 02.17.55.000 PM
       116 25-JUN-09 02.28.27.000 PM