What parameters are leaving? – 12c edition

As with every release, Oracle improves on the database product line.   Part of this improvement is the deprecation of parameters in leu of newer ones.  The V$PARAMETER view has a column called ISDEPRECATED, which is used for indicating if the parameter is leaving or not.  

 SQL to find the parameters that are being deprecated:

col name format a40
select name  
from v$parameter
where isdeprecated = 'TRUE'
order by 1;

Here are the parameters that are leaving. 

NAME
—————————————-
active_instance_count
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
fast_start_io_target
global_context_pool_size
instance_groups
lock_name_space
log_archive_local_first
log_archive_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_debug
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

 

Enjoy!

Twitter: @curtisbl294

Blog: https://dbasolved.com

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

%d bloggers like this: