签到成功

知道了

CNDBA社区CNDBA社区

Oracle 12cR2 中的弃用参数

2018-01-06 12:48 2240 0 原创 Oracle 18c
作者: Dave

可以通过v$parameter试图查看Oracle 12c中的弃用参数。总共26个。 查询如下:https://www.cndba.cn/dave/article/2544

https://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
https://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>

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

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Dave

Dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 1902
    原创
  • 2
    翻译
  • 456
    转载
  • 131
    评论
  • 访问:3641778次
  • 积分:3137
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by ZhiXinTech · 皖ICP备19020168号·

        QQ交流群