Hi Friends,
Today i have used one more feature of oracle 10g Addm. ADDM like statspack requires database snapshots which needs to be created .For this it uses Automatic Workload Repository (AWR) which maintains the repository of snapshots in SYSAUX tablespace.AWR take snaps after every 60mins and also take care to purge the snaps
To determine the amount of space in sysaux tablespace occupied by AWR use following views
v$sysaux_occupants
Also oracle 10g is available with packages DBMS_ADVISOR,DBMS_WORKLOAD_REPOSITORY to support automatic diagnosis using addm
To create snapshot execute the following as sys user
EXECUTE dbms_workload_repository.create_snapshot(‘TYPICAL’);
Also the parameter STATISTICS_LEVEL=TYPICAL or STATISTICS_LEVEL=ALL and also set TIMED_STATISTICS=TRUE
The easiest way to get the ADDM report is by executing:
@?/rdbms/admin/addmrpt
Also the snapshots which needed to comapared in addm report can be determined from the data dictionary view DBA_HIST_SNAPSHOT.
ALso the sample addm report which I generated is uploaded with this post
