From: "D Parent" <dparent6@home.com>
Subject: Re: database parameter
Date: 2000/07/07
Message-ID: <tHt95.57233$7I1.827648@news1.rdc2.on.home.com>#1/1
References: <k0495.1536$0x.49169@nuq-read.news.verio.net> <962908759.7347.0.pluto.d4ee154e@news.demon.nl>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc2.on.home.com 963012441 24.141.117.29 (Fri, 07 Jul 2000 16:27:21 PDT)
Organization: @Home Network Canada
NNTP-Posting-Date: Fri, 07 Jul 2000 16:27:21 PDT
Newsgroups: comp.databases.oracle.server


Use the following query ;

     SELECT name, value, isses_modifiable, issys_modifiable
     FROM v$parameter
     WHERE isses_modifiable <> 'FALSE OR
                     issys_modifiable <> 'FALSE'
     ORDER BY name;

 This should give you 76 parameters that are either session or system
modifiable without shutting down the instance .

   D Parent


Sybrand Bakker wrote in message
<962908759.7347.0.pluto.d4ee154e@news.demon.nl>...
>select * from v$parameter or show parameter in svrmgr
>
>the column is_ses_modifiable denotes whether or not an alter session
>statement is allowed (example sort_area_size) the column is_sys_modifiable
>denotes whether an alter system command is allowed (alter system set
>log_archive_start = true)
>Most values are not modifiable without changing the init.ora and bouncing
>the database.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>
>"SP" <spant1@aol.com> wrote in message
>news:k0495.1536$0x.49169@nuq-read.news.verio.net...
>> How can I look at database parameter.  Can I make the paramter changes
 when
>> the instance is up and running?  Thanks.
>> SP
>>
>>
>
>