Home » RDBMS Server » Server Administration » Alter System Reset................
Alter System Reset................ [message #262124] Fri, 24 August 2007 11:30 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

First i started the database with spfile and the value for UNDO_RETENTION was 700 as follows.

SQL> sho parameter undo_retention;

NAME                         TYPE        VALUE
----------------------    -----------  ------------

undo_retention               integer     700


After that i changed the value for UNDO_RETENTION as follows :-

SQL> alter system set undo_retention=800 scope=both sid='venkat';

System altered.

SQL> sho parameter undo_retention;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
undo_retention                       integer     800


After that i tried to use RESET,

SQL> alter system reset undo_retention scope=both sid='venkat';

System altered.

SQL> sho parameter undo_retention;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
undo_retention                       integer     800

When i use RESET will the value be deleted and value will become 0(ZERO) OR value will be

reverted to default value?
But i got 800 here.

Please guide me.

Regards,
Naveen

[Updated on: Fri, 24 August 2007 11:33]

Report message to a moderator

Re: Alter System Reset................ [message #262126 is a reply to message #262124] Fri, 24 August 2007 11:52 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You are on rac database?

Quote:
ALTER SYSTEM RESET applies to RACs only and you need to give the SID
parameter.


SQL> show parameter undo_retention

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_retention                       integer     900

SQL>  alter system set undo_retention=0;

System altered.

SQL>  show parameter undo_retention

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_retention                       integer     0

[Updated on: Fri, 24 August 2007 11:53]

Report message to a moderator

Re: Alter System Reset................ [message #262189 is a reply to message #262126] Fri, 24 August 2007 22:13 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

I am not using RAC.
If i had used RAC, then use "ALTER SYSTEM RESET",then

The value would be deleted and value will become 0(ZERO)
OR
The value will be reverted to default value i.e 900?
OR
UNDO_RETENTION=700, which was previous value.

Regards,
Naveen
Re: Alter System Reset................ [message #262283 is a reply to message #262124] Sat, 25 August 2007 22:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I don't experiment in RAC. But according to my conceot reset should give its default value.
Re: Alter System Reset................ [message #262574 is a reply to message #262283] Mon, 27 August 2007 10:44 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Restart your databse.
But its not an option.
Previous Topic: listener Issue
Next Topic: Oracle Version
Goto Forum:
  


Current Time: Fri Dec 09 00:30:39 CST 2016

Total time taken to generate the page: 0.09827 seconds