Home » RDBMS Server » Server Administration » Alter System
Alter System [message #287496] Wed, 12 December 2007 07:05 Go to next message
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
Re: Alter System [message #287498 is a reply to message #287496] Wed, 12 December 2007 07:08 Go to previous messageGo to next message
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.
Re: Alter System [message #287502 is a reply to message #287496] Wed, 12 December 2007 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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
Re: Alter System [message #287606 is a reply to message #287496] Wed, 12 December 2007 22:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Also depend on whether you start your database with pfile or spfile?
Re: Alter System [message #287619 is a reply to message #287606] Wed, 12 December 2007 23:31 Go to previous message
Michel Cadot
Messages: 64111
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:
  


Current Time: Tue Dec 06 00:24:42 CST 2016

Total time taken to generate the page: 0.21976 seconds