Home > tips > Does a database parameter value change need bouncing?

Does a database parameter value change need bouncing?

You need a quick look whether a db parameter needs bouncing the db.

issys_modifiable column in v$parameter view tells this. False dos not mean you cannot change it with ALTER SYSTEM, means a bouncing. I think this parameter name must be something like “issys_changeable_in_session” 🙂

issys_modifiable column name is easier to understand, if it is TRUE you can change in session with ALTER SESSION , FALSE then you cannot.

For sample parameters, below SQL Statement which produced this data:

SELECT   name, issys_modifiable
FROM   v$parameter
WHERE   name in (‘session_cached_cursors’,’object_cache_optimal_size’,’db_cache_size’);

db_cache_size IMMEDIATE No bouncing needed.
object_cache_optimal_size DEFERRED A new connection needed.
session_cached_cursors FALSE Bouncing needed.

For more detailed information:


Categories: tips Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!


Welcome to the world of Oracle with me....


News and reviews from the world of gadgets, gear, apps and the web


WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: