-
I'm trying to use logminer tool but I'm encountering some problems.
1) Sometimes it caused an error while I'm querying v$logmnr_contents and then it won't work until I restart the database. Have you ever had this problem? Is it frequent?
Is there a known way to fix it?
2) I'm trying to create a specific user dedicated to the analyse of log but haven't succeed yet. It seems there's a problem of rights as the scripts are owned by sys.
When I try to add a logfile to analyze I got this error :
"dbms_logmnr.NEW identifier undeclared"
Which rights should I give to this user in order to make it work?
3) Can we access the LGWR trace file?
4) In Oracle Documentation, it's said that queries that haven't been commited yet may be added to the redo log files. That means Oracle has a way to know that they haven't been commited in order to rollback them if needed. Do you know how?
-
Oracle keeps track of commits and etc through SCN (service change number) which is stored in the control file. So when you start the database, it would come to know what are the changes that are cmmited and what are yet to be commited.
On the other hand, the problem with LOGMINER could be a bug. Check the oracle metalink, technet site for a detail information on the logminer utility
Sam
