oracle12c技术参数,Oracle 12cR2 中的弃用参数

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

https://www.cndba.cn/dave/article/2544

https://www.cndba.cn/dave/article/2544https://www.cndba.cn/dave/article/2544

https://www.cndba.cn/dave/article/2544https://www.cndba.cn/dave/article/2544

https://www.cndba.cn/dave/article/2544https://www.cndba.cn/dave/article/2544https://www.cndba.cn/dave/article/2544

https://www.cndba.cn/dave/article/2544

https://www.cndba.cn/dave/article/2544

[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>

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