<< Click to Display Table of Contents >>

Log Miner

Top Previous Next

The page provides an interface to the Redo Log Miner utility that comes with Oracle 8i and later versions of the Oracle server.

The page shows two data grids and a SQL editor window. The second grid remains empty until the Log Miner has been started.

The upper grid shows the logfiles that have been added to the Log Miner utility:

File name

Low time

High time

Database time

Reset SCN

Reset SCN time

Low SCN

Next SCN

Status

Info

The context toolbar and the right mouse button popup menu permit the following operations:

 

Create Log Miner Dictionary

Shows a modal dialog for creating a Log Miner dictionary file. This is the first step that is needed to work with the Log Miner utility.

 

Add Logfile

Shows a modal dialog for adding an existing redo logfile to the Log Miner

 

Remove Logfile

Removes a logfile that was previously added.

 

Start Log Miner

Starts the Log Miner utility.

 

End Log Miner

Ends the Log Miner

 

Grid View

For more information, see object window

 

After the Log Miner has started, the second grid shows the contents of the current redo log file. These are taken from V$LOGMNR_CONTENTS:

User Name

Timestamp

SCN (System change number)

LOG_ID

XIDUSN (Transaction ID undo segment number )

XIDSLT (Transaction ID slot number )

XIDSQN (Transaction ID sequence number )

RBASQN (RBA sequence number of the log)

RBABLK (RBA block number within the log file)

RBABYTE (RBA byte offset within the block)

UBAFIL (UBA file number of the file containing the undo block)

UBABLK (UBA block number for the undo block)

UBAREC (UBA record index within the undo block)

UBASQN (UBA undo block sequence number)

ABS_FILE number (Data block absolute file number)

REL_FILE number (Data block relative file number)

DATA_BLK number (Data block number)

DATA_OBJ number (Data block object number)

DATA_OBJD number (Data block data object number)

SEG_OWNER

SEG_NAME

SEG_TYPE

SEG_TYPE_NAME

TABLE_SPACE

ROW_ID

SESSION number

SERIAL number

SESSION_INFO

ROLLBACK

OPERATION

SQL_REDO

SQL_UNDO

RS_ID (Record set id)

SSN (SQL sequence number)

CSF (Continuation SQL flag)

INFO (Informational message)

STATUS

The SQL window below the grid shows either the full ReDo SQL or the UnDo SQL statement, depending on which tab is activated below the edit window.