Topic : Managing Diagnostic data

What are the differences between LMTS and DMTS?


Answer :

Tablespaces that record extent allocation in the dictionary are called dictionary managed tablespaces; and tablespaces that record extent allocation in the tablespace header are called locally managed tablespaces.

Show Answer Discuss

When will oracle perform Health Monitor check?


Answer :

When serious problem occurs oracle automatically perform Health Monitor Check.

Show Answer Discuss

Where is default diagnostic destination is located?


Answer :

ORACLE_BASE/diag/rdbms/database name/SID/

Show Answer Discuss

Which view is used to list all important ADR locations for current oracle database instance?


Answer :

V$diag_info

Show Answer Discuss

What factors make oracle to perform Health Monitor check?


Answer :

Undo corruption; Redo corruption; data dictionary corruption; block corruption etc.

Show Answer Discuss