OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Alter System

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

Alter System [message #287496]

Wed, 12 December 2007 07:05

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hi,

When we do any Alter System Changes, does this changes go away when restart the Instance.

Thanks

Abdul

Report message to a moderator

Re: Alter System [message #287498 is a reply to message #287496]

Wed, 12 December 2007 07:08

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Not clear your question for me. please provide more details.
what is actual requirement.

Report message to a moderator

Re: Alter System [message #287502 is a reply to message #287496]

Wed, 12 December 2007 07:14

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Depending on which alter system you make it goes effect either:
- immediately for all sessions
- immediately for future sessions
- after restart

Regards
Michel

Report message to a moderator

Re: Alter System [message #287606 is a reply to message #287496]

Wed, 12 December 2007 22:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Also depend on whether you start your database with pfile or spfile?

Report message to a moderator

Re: Alter System [message #287619 is a reply to message #287606]

Wed, 12 December 2007 23:31

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And it also depends the scope option you specified (or not) on the "alter system" command as explained in the SQL Reference.

Regards
Michel

[Updated on: Wed, 12 December 2007 23:31]

Report message to a moderator

Previous Topic:	Query with Logminer
Next Topic:	ORA-01157: ORA-01110:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 10:39:02 CDT 2024