Re: Alter Session vs Alter System
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 22 Sep 2009 06:29:37 +0200
Message-ID: <4ab852af$0$22865$426a74cc_at_news.free.fr>
NUM
NAME
TYPE
VALUE
DISPLAY_VALUE
ISDEFAULT
ISSES_MODIFIABLE
ISSYS_MODIFIABLE
ISINSTANCE_MODIFIABLE
ISMODIFIED
ISADJUSTED
ISDEPRECATED
DESCRIPTION
UPDATE_COMMENT
HASH Regards
Michel Received on Mon Sep 21 2009 - 23:29:37 CDT
Date: Tue, 22 Sep 2009 06:29:37 +0200
Message-ID: <4ab852af$0$22865$426a74cc_at_news.free.fr>
"indytoatl" <indytoatl_at_gmail.com> a écrit dans le message de news:
1f6fed5a-358e-44ad-a632-fe1c9f6ec1fb_at_d34g2000vbm.googlegroups.com...
| How can I determine which initialization parameters I can be changed
| using ALTER SESSION, and which can be changed using ALTER SYSTEM. Is
| there a query i can run?
SQL> desc v$parameter
Name
NUM
NAME
TYPE
VALUE
DISPLAY_VALUE
ISDEFAULT
ISSES_MODIFIABLE
ISSYS_MODIFIABLE
ISINSTANCE_MODIFIABLE
ISMODIFIED
ISADJUSTED
ISDEPRECATED
DESCRIPTION
UPDATE_COMMENT
HASH Regards
Michel Received on Mon Sep 21 2009 - 23:29:37 CDT