oracle awr report 汇报

2012-07-29

oracle awr report 报告Taking an AWR snapshot (10g and beyond)EXEC dbms_workload_repository.create_s

oracle awr report 报告
Taking an AWR snapshot (10g and beyond)
    EXEC dbms_workload_repository.create_snapshot;

    Taking a STATSPACK snapshot:

    EXEC statspack.snap;

To execute a STATSPACK or AWR report, go to your $ORACLE_HOME/rdbms/admin directory and run:
all awr report:
    awrrpt.sql
    spreport.sql

for specific sql:
@?/rdbms/admin/awrsqrpt