1.

List The Log Miner Procedures?

Answer»

Log MINER procedures are given as follows:

  • ADD_LOGFILE – Adds a file to the existing or newly created list of archive files to process.
  • START_LOGMNR – Initializes the LogMiner utility.
  • END_LOGMNR – Finishes a LogMiner session.

The following two functions can also be used with log MINERS:

  • MINE_VALUE (function) – RETURNS undo or redo VALUE for the column specified as parameter BASED on the data present in the v$logmnr_contents view.
  • COLUMN_PRESENT ( function) – Verifies whether undo or redo values is present in the v$logmnr _contents view for the column specified as parameter.

Log miner procedures are given as follows:

The following two functions can also be used with log miners:


Discussion

No Comment Found

Related InterviewSolutions