Home » RDBMS Server » Server Administration » what was the parameter before it has been changed
what was the parameter before it has been changed [message #274089] Sat, 13 October 2007 12:23 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
hi all,
let's say a parameter changed in the database
ex:
alter system set retention_target=1500;
and i want to know what was the old value before it has been changed , is there any way to know?
thanks for reading.
Re: what was the parameter before it has been changed [message #274091 is a reply to message #274089] Sat, 13 October 2007 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
SQL> select value from v$parameter where name = 'retention_target';
SQL> alter system set retention_target=1500;
Re: what was the parameter before it has been changed [message #274100 is a reply to message #274089] Sat, 13 October 2007 17:52 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
dear anacedent
if want to increase the number of posts do it in onother place, if don't understande my question read it again.

[mod-edit] removed illiterate IM speak.

[Updated on: Mon, 15 October 2007 08:01] by Moderator

Report message to a moderator

Re: what was the parameter before it has been changed [message #274101 is a reply to message #274100] Sat, 13 October 2007 17:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Read Forum Guide and don't use IM speak
2/ Read forum Guide and be polite
3/ Ana doesn't care about posts number and if you'd read a little bit more Oracle forums here and elsewhere you knew it
4/ Ana's answer is correct if you try to understand it. I explain: save the value before changing it
5/ Otherwise you can't

Regards
Michel
Re: what was the parameter before it has been changed [message #274102 is a reply to message #274089] Sat, 13 October 2007 18:54 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
> if u don't understande my question read it again.
If you have a different, 100% reliable answer, post it here.

P.S.
"u" is not a member of this forum.

[Updated on: Sat, 13 October 2007 18:54] by Moderator

Report message to a moderator

Re: what was the parameter before it has been changed [message #274134 is a reply to message #274102] Sun, 14 October 2007 08:08 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"u", as we know, is an abbreviation of "uuu". And yes, we have uuu as one of the OraFAQ Forum users.
Previous Topic: I did not really understand this problem!
Next Topic: oracle packs
Goto Forum:
  


Current Time: Wed Dec 07 04:58:10 CST 2016

Total time taken to generate the page: 0.10405 seconds