Oracle11 generates an AWR report

The AWR report is generated as follows: 1. log on to the Oracle database: sqlplusassysdba2. In sqlplus, run the following command as a sys user,

The AWR report is generated as follows: 1. log on to the Oracle database: sqlplus/as sysdba 2. In sqlplus, run the following command as a sys user,

The AWR report is generated as follows:

1. log on to the Oracle database:

Sqlplus/as sysdba

2. In sqlplus, run the following command as sys to generate the first performance data snapshot:

Exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (flush_level => 'all ');

3. Run all or many of the applications or SQL statements you have found with poor performance to keep the system under high pressure (such as CPU or IO usage ), and keep this status from half an hour to one hour.

4. In sqlplus, run the following command again to generate a second performance data snapshot:

Exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (flush_level => 'all ');

5. In sqlplus, run the following command as sys to generate a performance report:

@? /Rdbms/admin/awrrpt. SQL

As prompted, select the two generated performance data snapshots and generate a final AWR performance report.