Home » RDBMS Server » Server Administration » Is there a way to track changes in system parameters? (merged)
Is there a way to track changes in system parameters? (merged) [message #239977] Wed, 23 May 2007 15:48 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Do NOT cross/multi-post
http://www.orafaq.com/forum/t/82276/74940/
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
AUDIT is one way.
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 Go to previous messageGo to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
Is audit the only way ?
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
LOGMINER should be able to extract the desired information, too.
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 Go to previous messageGo to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
Could you show me some example ?

Thanks
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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

Re: Is there a way to track changes in system parameters? (merged) [message #240059 is a reply to message #239996] Thu, 24 May 2007 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database trigger could be another way.

Regards
Michel
Re: Is there a way to track changes in system parameters? (merged) [message #240137 is a reply to message #240059] Thu, 24 May 2007 04:12 Go to previous messageGo to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
What type of trigger could track the "alter system" ?

Thanks
Re: Is there a way to track changes in system parameters? (merged) [message #240152 is a reply to message #240137] Thu, 24 May 2007 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER I think.

Regards
Michel
Re: Is there a way to track changes in system parameters? (merged) [message #240224 is a reply to message #240152] Thu, 24 May 2007 07:14 Go to previous message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
But alter is only for objects...
Previous Topic: how to find the client ip address
Next Topic: catpatch.sql
Goto Forum:
  


Current Time: Sat Dec 03 01:36:17 CST 2016

Total time taken to generate the page: 0.07103 seconds