10g dba review

12 proactive

Awr - statistics snapshot & workload repository.

Then -- Automated tasks(correct auto), or Server Alerts(can not be corrected auto), or Advisory.

Base line: normal running status(app statistics-transaction volume, response time; db statistics; os statistics; I/O; network statistics). Metric: rate of change in a cumulative statistics. Statistics/Threshold.

Optimizer statistics -- auto; or manual dbms_stats.gather_table_stats. (stored in data dictionary). -->normally auto collected by job(stale, invalid).  When manually?

Statistics_level: basic, typical, all(rarely, extra SQL diagnostics info.

AWR: admin package,  retention period/collection interval/collection level.

ADDM: Automatic Diagnostic Monitor.  CPU, SQL etc.  Finding/recommendation.

Advisory: SQL, memory(PGA, SGA), space(segment, undo), backup(MTTR).   After, sql recommendation:  index, tuning instance, rewrite sql statement, etc.

System Alerts: tbs usage(critical, warning),  ... setting threshold/test alert.

13 Performance

ASSM:(Automatic Shared Memory Management)

Dynamic Performance statistics:

v$sysstat, v$sessstat, v$service_stats, --cumulative stats.

v$system_event/session/service.    v$statname, v$eventname.

14, BR concepts,  fast_start_mttr_target.

17, Flashback

Fast: only changes is restored. (by row or by transaction)

Flashback database use flashback logs(before images). Flashback Drop use recycle bin. Others use undo data.  (?why can not use redo -->that's traditional way :))

 

DBA II skip

Only logical error not physical error.

Table flashback - rowmovement must be enabled.