ADDM

ADDM
ADDM performs its analysis on data that has been captured and stored in AWR. For
ADDM, the default collection interval for a snapshot is one hour.
Generally, ADDM is used for identifying systemwide systemic problems. It calls
attention to performance problems that include:
■ Resource contention (bottlenecks), such as when your database is using large
amounts of CPU time or memory due to high load SQL statements
■ Poor connection management, such as when your application is making too many
logins to the database
■ Lock contention in a multiuser environment, such as when one user process
acquires a lock to safely update data in a table, causing other user processes that
must acquire locks against the same table to wait, resulting in a slower database
performance
... zobacz całą notatkę