Shulou(Shulou.com)06/01 Report--

SELECT dbid, baseline_name, baseline_type, moving_window_size from dba_hist_baseline DBID BASELINE_NAME BASELINE_TYPE MOVING_WINDOW_SIZE-- -536511065 SYSTEM_MOVING_WINDOW MOVING_WINDOW 8begindbms_workload_repository.modify_snapshot_settings (interval= > 60) Retention= > 90,24,60) End;col RETENTION for a20select * from dba_hist_wr_control DBID SNAP_INTERVAL RETENTION TOPNSQL -536511065 + 00000 01VR 00.0 + 00090 0000VOV 00.0 DEFAULT select snap_id To_char (begin_interval_time, 'YYYY-MM-DD'), to_char (end_interval_time,' YYYY-MM-DD') from dba_hist_snapshot order by snap_id

Generate AWR manually:

Exec dbms_workload_repository.create_snapshot (); AWR data exists in sysaux table space SQL > select OCCUPANT_NAME,OCCUPANT_DESC,SCHEMA_NAME,SPACE_USAGE_KBYTES/1024 "MB" from V$SYSAUX_OCCUPANTS WHERE OCCUPANT_NAME LIKE'% AWR%' OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME MB SM/AWR Server Manageability-Automatic Workload Repository SYS 216.81SQL > select TABLE_NAME PARTITION_NAME,TABLESPACE_NAME from dba_tab_partitions where table_name like 'WR%' and rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.