Re: database parameter

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_at_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_at_aol.com> wrote in message
>news:k0495.1536$0x.49169_at_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
>>
>>
>
>
Received on Fri Jul 07 2000 - 00:00:00 CDT