~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
1396446622 1 ORCL orcl YL-XMK3DB2-D
EV
* 4157808399 1 K3DBSIT k3dbsit YL-XMK3DB2-D
EV
1396446622 2 ORCL orcl2 yl-xmk3db2
Using 4157808399 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:
SYS@k3dbsit>select * from dba_hist_wr_control;
DB Id SNAP_INTERVAL RETENTION TOPNSQL
----------- -------------------- -------------------- ----------
4157808399 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
1396446622 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
为什么没有AWR生成呢
评论
有用 0
墨值悬赏