| Alter System Reset................ [message #262124] |
Fri, 24 August 2007 11:30  |
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  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
