Friday, August 27, 2010

How to check deprecated parameters in Oracle 11g


SQL> SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE'
  2* order by name;
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
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

25 rows selected.

No comments: