modifiability of system parameters

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Tue, 28 Aug 2001 22:05:52 +0800
Message-ID: <br7not0r45qcclmia2miho21o5khpbpgun@4ax.com>

Dear all,

I try to modify a system parameter with 'alter system', but I cannot.

<SQL*plus begin>

SQL> select name, value, isses_modifiable, issys_modifiable, ismodified from v$parameter
  2 where name like '%check%';

NAME                           VALUE      ISSES ISSYS_MOD ISMODIFIED
------------------------------ ---------- ----- --------- ----------
db_block_checksum              FALSE      FALSE IMMEDIATE FALSE
log_checkpoint_interval        10000      FALSE IMMEDIATE FALSE
log_checkpoint_timeout         1800       FALSE IMMEDIATE FALSE
log_checkpoints_to_alert       FALSE      FALSE FALSE     FALSE
db_block_checking              FALSE      TRUE  DEFERRED  FALSE

SQL> alter session set db_block_checking=false;

Session altered.

SQL> alter system set db_block_checking=true; alter system set db_block_checking=true

                                      *

ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

<SQL*plus end>

<doc begin>

ORA-02096 specified initialization parameter is not modifiable with this option

Cause: Though the initialization parameter is modifiable, it cannot be modified using the specified command.

Action: Check the Oracle8i Administrator's Guide for information about under what scope the parameter may be modified

<doc end>

Anyone knows:
1.why can't I modify it with 'alter system'? 2.how can we get possible values of system parameters?

Thanks,
Dino Received on Tue Aug 28 2001 - 09:05:52 CDT