OraFAQ Forum: Server Administration » How to reset the parameter value?

Home » RDBMS Server » Server Administration » How to reset the parameter value? (oracle10g Redhatas4u4)

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

How to reset the parameter value? [message #534809]

Fri, 09 December 2011 05:43

wxfjordan
Messages: 92
Registered: December 2006

Member

I often use "alter session set xxx=xxx;" command to change parameter value temporarily. After that, how to reset parameter value to default and I don't want logout sqlplus.

Report message to a moderator

Re: How to reset the parameter value? [message #534810 is a reply to message #534809]

Fri, 09 December 2011 05:45

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Use the same command to turn it back?

'sho parameter XXX' before altering session will show you what it was.

Report message to a moderator

Re: How to reset the parameter value? [message #534812 is a reply to message #534810]

Fri, 09 December 2011 06:26

wxfjordan
Messages: 92
Registered: December 2006

Member

Just this way. can somebody introduce another?

Report message to a moderator

Re: How to reset the parameter value? [message #534817 is a reply to message #534812]

Fri, 09 December 2011 06:37

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select value from v$parameter where name='XXX'

Regards
Michel

Report message to a moderator

Previous Topic:	oracle 11g ora-04031
Next Topic:	Purge Recyclebin(What is dba_recyclebin.can_purge?)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 11:38:24 CDT 2025