OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Query with Logminer (oracle,10g,HPUX 11.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query with Logminer [message #286191]

Thu, 06 December 2007 16:38

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

Report message to a moderator

Re: Query with Logminer [message #286193 is a reply to message #286191]

Thu, 06 December 2007 16:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Metalink Doc ID: Note:62508.1

Report message to a moderator

Re: Query with Logminer [message #286194 is a reply to message #286191]

Thu, 06 December 2007 17:12

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?

Report message to a moderator

Re: Query with Logminer [message #286195 is a reply to message #286191]

Thu, 06 December 2007 17:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What business problem are you really trying to solve?

Report message to a moderator

Re: Query with Logminer [message #286197 is a reply to message #286191]

Thu, 06 December 2007 18:52

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 ?

Report message to a moderator

Re: Query with Logminer [message #286224 is a reply to message #286197]

Thu, 06 December 2007 23:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator