可以通过v$parameter试图查看Oracle 12c中的弃用参数。总共26个。 查询如下：

[oracle@www.cndba.cn/dave ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 6 12:40:50 2018
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
SQL> set lines 130
SQL> select * from v$version;

BANNER                                             CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production          0
PL/SQL Release 12.2.0.1.0 - Production                              0
CORE    12.2.0.1.0    Production                                  0
TNS for Linux: Version 12.2.0.1.0 - Production                          0
NLSRTL Version 12.2.0.1.0 - Production                              0

SQL> set pages 200
SQL> col name for a40
SQL> col description for a80
SQL> SELECT name,DESCRIPTION from v$parameter WHERE isdeprecated ='TRUE' ORDER BY name;

NAME                     DESCRIPTION
---------------------------------------- -------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY         Version 7 Dictionary Accessibility Support
active_instance_count             number of active instances in the cluster database
asm_preferred_read_failure_groups     preferred read failure groups
background_dump_dest             Detached process dump directory
buffer_pool_keep             Number of database blocks/latches in keep buffer pool
buffer_pool_recycle             Number of database blocks/latches in recycle buffer pool
commit_write                 transaction commit log write behaviour
cursor_space_for_time             use more memory in order to get faster execution
db_block_buffers             Number of database blocks cached in memory
fast_start_io_target             Upper bound on recovery reads
instance_groups              list of instance group names
lock_name_space              lock name space used for generating lock names for standby/clone database
log_archive_start             start archival process on SGA initialization
parallel_adaptive_multi_user         enable adaptive setting of degree for multiple user streams
plsql_debug                 PL/SQL debug
plsql_v2_compatibility             PL/SQL version 2.x compatibility flag
rdbms_server_dn              RDBMSs Distinguished Name
remote_os_authent             allow non-secure remote clients to use auto-logon accounts
resource_manager_cpu_allocation      Resource Manager CPU allocation
sec_case_sensitive_logon         case sensitive password enabled for logon
serial_reuse                 reuse the frame segments
sql_trace                 enable SQL trace
standby_archive_dest             standby database archivelog destination text string
unified_audit_sga_queue_size         Size of Unified audit SGA Queue
user_dump_dest                 User process dump directory
utl_file_dir                 utl_file accessible directories list

26 rows selected.

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。