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/
Author
Rugal Bernstein
Posted on
June 24, 2014
Licensed under