Logminer
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
Oracle LogMiner is an Oracle database facility that allows data in redo log files to be extracted and analysed.
LogMiner is typically used to:
- Track database changes for audit purposes
- Undo user errors or logical corruption
After mining the logs, query the V$LOGMNR_CONTENTS view to list all logical change operation conducted on the database. The rows will contain both redo SQL and undo SQL.
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
