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 a40select 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:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Thanks for shening. I read many of your blog posts, cool, your blog is very good.