a2zinterviews

29.	List the log miner procedures?
	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.
	Discuss Your Name Your Email-ID Your Answer

30.	How can you process messages in order asynchronously?
	Oracle provides a package called dbms_aq package to queue the messages, which can be consumed by another session or application in order.
	Discuss Your Name Your Email-ID Your Answer

31.	How would you determine who has added a row to a table?
	This can be determined by using the fine grained auditing feature for the table.
	Discuss Your Name Your Email-ID Your Answer

32.	How can you initialize log miner?
	You can use the DBMS_LOGMNR.START_LOGMNR procedure to initialize the log miner.
	Discuss Your Name Your Email-ID Your Answer