How to check deprecated parameters in any version of oracle:
Solution: From v$parameter view
Heres a sample from version 11.1.0.7
SQL> select NAME from v$parameter where ISDEPRECATED='TRUE';
NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
buffer_pool_keep
buffer_pool_recycle
max_commit_propagation_delay
log_archive_start
standby_archive_dest
log_archive_local_first
parallel_server
parallel_server_instances
NAME
--------------------------------------------------------------------------------
fast_start_io_target
serial_reuse
max_enabled_roles
remote_os_authent
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write
NAME
--------------------------------------------------------------------------------
sql_trace
parallel_automatic_tuning
sql_version
drs_start
26 rows selected.
Solution: From v$parameter view
Heres a sample from version 11.1.0.7
SQL> select NAME from v$parameter where ISDEPRECATED='TRUE';
NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
buffer_pool_keep
buffer_pool_recycle
max_commit_propagation_delay
log_archive_start
standby_archive_dest
log_archive_local_first
parallel_server
parallel_server_instances
NAME
--------------------------------------------------------------------------------
fast_start_io_target
serial_reuse
max_enabled_roles
remote_os_authent
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write
NAME
--------------------------------------------------------------------------------
sql_trace
parallel_automatic_tuning
sql_version
drs_start
26 rows selected.
No comments:
Post a Comment