If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Issys_modifiable - deferred

Hi -

As per Oracle document if the parameter value in ISSYS_MODIFIABLE column ( in v$parameter view ) is ...

*IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
*DEFERRED - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
*FALSE - Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.

ISSYS_MODIFIABLE value for audit_file_dest parameter is DEFERRED. I set the new value for this parameter but it is not showing in subsequent sessions. It accepted scope=spfile only and the change affected only after bouncing the database.

Can some one clarify me that ISSYS_MODIFIABLE = DEFERRED parameters are static or dynamic?

Thanks,

Vijay Tummala

Try hard to get what you like OR you will be forced to like what you get.