Home » RDBMS Server » Server Administration » Query with Logminer (oracle,10g,HPUX 11.1)
Query with Logminer [message #286191] Thu, 06 December 2007 16:38 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Can i enable supplemental logging without running the logminer install package
i,e @?/rdbms/admin/dbmslm.sql?

Thanks in advance
Re: Query with Logminer [message #286193 is a reply to message #286191] Thu, 06 December 2007 16:47 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
Metalink Doc ID: Note:62508.1
Re: Query with Logminer [message #286194 is a reply to message #286191] Thu, 06 December 2007 17:12 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
can i issue 'alter database enable supplemental log data' and install the package afterwards whenever i have to analyze the logs does't it put information into the log without installing the logminer package?
Re: Query with Logminer [message #286195 is a reply to message #286191] Thu, 06 December 2007 17:29 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
What business problem are you really trying to solve?
Re: Query with Logminer [message #286197 is a reply to message #286191] Thu, 06 December 2007 18:52 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Just as a substitute for auditing i need to implement minimal supplemental logging and i enabled it without actually installing the logminer package ,so my question is compulsary to install the package to enable supplemental logging ?
Re: Query with Logminer [message #286224 is a reply to message #286197] Thu, 06 December 2007 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can activate supplemental logging without logminer package.
You can't have any benefit of the supplemental logging without logminer.

Regards
Michel
Re: Query with Logminer [message #286521 is a reply to message #286191] Fri, 07 December 2007 16:56 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Thanks everyone.
Re: Query with Logminer [message #287564 is a reply to message #286191] Wed, 12 December 2007 12:44 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Logminer package is part of standard installation?
Re: Query with Logminer [message #287566 is a reply to message #287564] Wed, 12 December 2007 12:50 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Database Utilities
Chapter 17 Using LogMiner to Analyze Redo Log Files

Regards
Michel
Previous Topic: Different between ROLLBACK and COMMIT
Next Topic: Alter System
Goto Forum:
  


Current Time: Tue Dec 06 14:02:51 CST 2016

Total time taken to generate the page: 0.13759 seconds