OraFAQ Forum: Server Administration » Is there a way to track changes in system parameters? (merged)

Home » RDBMS Server » Server Administration » Is there a way to track changes in system parameters? (merged)

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

Is there a way to track changes in system parameters? (merged) [message #239977]

Wed, 23 May 2007 15:48

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Is there a way to track changes in system parameters ( alter system ) ?

Thanks in advance

Report message to a moderator

Re: Is there a way to track changes in system parameters ( alter system ) ? [message #239979 is a reply to message #239977]

Wed, 23 May 2007 15:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there a way to track changes in system parameters ( alter system ) ?
There are many ways; manual procedure by writing down, source code control system, automated DBMS_JOB, etc.

Report message to a moderator

Re: Is there a way to track changes in system parameters ( alter system ) ? [message #239980 is a reply to message #239977]

Wed, 23 May 2007 15:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Do NOT cross/multi-post
http://www.orafaq.com/forum/t/82276/74940/

Report message to a moderator

Re: Is there a way to track changes in system parameters ( alter system ) ? [message #239991 is a reply to message #239979]

Wed, 23 May 2007 16:40

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Thanks but I think you got me wrong. If somebody issues a "alter system" statement, how to know when and who issued the "alter system". Is there any type of trigger or any other way ? I'm a DBA and I wanna be notified when another dba issues an "alter system" to change a parameter.

Thanks in advance

Report message to a moderator

Re: Is there a way to track changes in system parameters? (merged) [message #239993 is a reply to message #239977]

Wed, 23 May 2007 16:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

AUDIT is one way.

Report message to a moderator

Re: Is there a way to track changes in system parameters? (merged) [message #239996 is a reply to message #239993]

Wed, 23 May 2007 16:56

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Is audit the only way ?

Report message to a moderator

Re: Is there a way to track changes in system parameters? (merged) [message #239997 is a reply to message #239977]

Wed, 23 May 2007 17:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

LOGMINER should be able to extract the desired information, too.

Report message to a moderator

Re: Is there a way to track changes in system parameters? (merged) [message #240000 is a reply to message #239997]

Wed, 23 May 2007 17:10

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Could you show me some example ?

Thanks

Report message to a moderator

Re: Is there a way to track changes in system parameters? (merged) [message #240004 is a reply to message #239977]

Wed, 23 May 2007 17:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Could you show me some example ?
I have neither the time nor inclination to spoonfeed you a solution.
If others want to do your job for you, that is their choice.
You claim to be a DBA, but seem uninformed WRT Oracle & unwilling to take a clue & develop your own solution.

Perhaps you should ask the other DBAs, who you want to monitor, if they can solve this challenge for you.

You're On Your Own (YOYO)!

[Updated on: Wed, 23 May 2007 17:38] by Moderator

Report message to a moderator