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

Please follow and like: