some oracle tools and introduction
ASH
active session history
recording trace and performance for each SQL in different grade:
instance/database/session/service/…
recording single SQL
AWR
automatic workload repository
monitoring database’s performance includes I/O, CPU, latch, lock, log file, buffer usage log, redo log size, (soft/hard)parse
snapshot the whole database performance
ADDM
automatic database diagnostic monitor
ADDM is a self diagnostic engine designed from the experience of Oracle’s best tuning experts
Analyzes AWR data automatically after an AWR snapshot
automatically generate diagnostic report after analyse AWR
v$fixed_table
This view displays all dynamic performance tables, views, and derived tables in the database.
Some V$tables
(for example, V$ROLLNAME
) refer to real tables and are therefore not listed.
DICTIONARY
DICTIONARY
contains descriptions of data dictionary tables and views.
some oracle tools and introduction
https://rug.al/2014/2014-06-24-some-oracle-tools-and-introduction/