Examples of Mining by Explicitly Specifying the Redo Log Files of Interest

The following examples demonstrate how to use LogMiner when you know which redo log files contain the data of interest. This section contains the following list of examples; these examples are best read sequentially, because each example builds on the example or examples that precede it:

• Example 1: Finding All Modifications in the Last Archived Redo Log File

• Example 2: Grouping DML Statements into Committed Transactions

• Example 3: Formatting the Reconstructed SQL

• Example 4: Using the LogMiner Dictionary in the Redo Log Files

• Example 5: Tracking DDL Statements in the Internal Dictionary

• Example 6: Filtering Output by Time Range

The SQL output formatting may be different on your display than that shown in these examples.