Re: database parameter

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/06
Message-ID: <962908759.7347.0.pluto.d4ee154e@news.demon.nl>#1/1

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 Thu Jul 06 2000 - 00:00:00 CDT