Wednesday, March 16, 2011

How to check deprecated parameters

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.






No comments:

Post a Comment