SQL> select name from v$database;
NAME
---------
PROD
SQL>
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
Below are the list of deprecated parameters in 11g.
====================================
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.
Below command is not displaying the deprecated parameters.
=======================================
SQL> select name from v$obsolete_parameter where isspecified='TRUE';
no rows selected
SQL>
Note:Parameters which are replaced in 11g.
|
GREAT JOB !!!! ... CHEER UP ..... !!!!
ReplyDelete