From Oracle FAQ
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|