logminer not showing SQL

logminer not showing SQL

 

  





Hi! Gurus

Can anybody through light on the problem i am facing in logminer.


Thanks in advance

Regards
Venugopal Tadepalli
----- Forwarded by Venugopal Tadepalli/MGR/DCC/UTI Bank on 03/04/2005 09:34
AM -----

Venugopal
Tadepalli To: [Email address protected]
Sent by: cc:
Venugopal Subject: logminer oracle 9i
Tadepalli


03/02/2005 01:31
PM





I am not able to see the sql statements in the sql_redo column
v$logmnr_contents view when using log miner.
Can anybody tell me the reason? Is supplemental logging the reason? What is
the performance impact if supplemental logging is enabled? Are there any
standby issues involved in enabling supplemental logging? How to enable
minimal supplemental logging?


Thanks in advance

Venugopal Tadepalli
Oracle DBA
UTI Bank


Oracle LazyDBA home page