Re: Alter Session vs Alter System

From: gazzag <gareth_at_jamms.org>
Date: Tue, 22 Sep 2009 02:00:08 -0700 (PDT)
Message-ID: <295ca16f-f03f-4b34-bad6-a1ac0210c501_at_e34g2000vbm.googlegroups.com>

On 22 Sep, 05:29, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "indytoatl" <indyto..._at_gmail.com> a écrit dans le message de news:
> 1f6fed5a-358e-44ad-a632-fe1c9f6ec..._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

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2012.htm#I1030176

HTH -g Received on Tue Sep 22 2009 - 04:00:08 CDT