AWR Report
AWR Report
AWR Report
SQL statistics
Time-model statistics
Wait statistics
time model stats (db time, java execution time, pl/sql execution time, etc)
v$osstat
v$service_stats
v$sysstat
system stats
v$sesstat
session stats
all - same as typical but includes execution plans and timing info
from the O/S
Active
De-active
Display
To change the snapshot interval and how many days the snapshots are
kept you use the package dbms_workload_repository or Enterprise
Manager
Snapshot configuration
Change snapshotting values
Display values
Snapshot Management
Create a snapshot
exec dbms_workload_repository.create_snapshot;
Delete snapshots
Create a baseline
Delete a baseline
Display snapshots
Useful Views
dba_hist_active_sess_history ASH info (see below)
dba_hist_baseline
baseline info
dba_hist_database_instance
environment data
dba_hist_sql_plan
dba_hist_wr_control
AWR settings
dba_hist_snapshot
AWR Report
To run AWR report you can use the following operating system scripts or
use Enterprise Manager.
awrrpt.sql
the script will ask for begin snapshot and end snapshot and will be generated in text
format
Note: reports went in $oracle_home\db_1\bin
awrrpti.sql
the script will ask for begin snapshot and end snapshot and will be generated in HTML
format
Note: reports went in $oracle_home\db_1\bin