OraFAQ Forum: SQL & PL/SQL » Diff between Alter Session and Alter system

Home » SQL & PL/SQL » SQL & PL/SQL » Diff between Alter Session and Alter system (Oracle 11g)

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

Diff between Alter Session and Alter system [message #587923]

Wed, 19 June 2013 06:23

baskar.gouda@sun.com
Messages: 4
Registered: June 2009
Location: CHENNAI

Junior Member

Hi,
What is the difference between alter session and alter system?

Thanks-Bhaskar

Report message to a moderator

Re: Diff between Alter Session and Alter system [message #587924 is a reply to message #587923]

Wed, 19 June 2013 06:30

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

Hi,

The answer is in the doucmentation
http://docs.oracle.com/cd/A97630_01/server.920/a96540/statements_23a.htm#2053604
Quote:

. . .
Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted.
. . .

http://docs.oracle.com/cd/A97630_01/server.920/a96540/statements_22a.htm
Quote:

. . .
Use the ALTER SESSION statement to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database.
. . .

Regards,
Dariyoosh

Report message to a moderator

Re: Diff between Alter Session and Alter system [message #587925 is a reply to message #587923]

Wed, 19 June 2013 06:30

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

alter session affects the current session only, alter system affects the entire system.

Report message to a moderator

Previous Topic:	Error in reading data from collection variable for ref cursor.
Next Topic:	String Split/ String replace based on character length

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 04 22:49:16 CDT 2025