Oracle数据库中,deprecate和desupport的区别,以及Oracle 12.2中的deprecate 的参数

来源：互联网发布：淘宝祝福语编辑：程序博客网时间：2024/05/15 19:10

摘自:图书<<Oracle Database 12c New Feature>> 第424页,英文版,Robert G.Freeman著.

在oracle database中,
一个deprecate feature是指:
Oracle 已经表示(indicate)该特性会在某个时间点停止支持,但是在该产品中依然可用.

一个desupport feature是指:
Oracle 不再支持,不再做bug-fix,并且事实上,该特性将会从product中移除.

如下sql查询出Oracle Database 12.2 deprecate 的参数.

[oracle@db12cr2 bin]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 05:39:28 2017Copyright (c) 1982, 2016, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> set pages 300SQL> select name from v$parameter where isdeprecated='TRUE' order by name;NAME--------------------------------------------------------------------------------O7_DICTIONARY_ACCESSIBILITYactive_instance_countasm_preferred_read_failure_groupsbackground_dump_destbuffer_pool_keepbuffer_pool_recyclecommit_writecursor_space_for_timedb_block_buffersfast_start_io_targetinstance_groupslock_name_spacelog_archive_startparallel_adaptive_multi_userplsql_debugplsql_v2_compatibilityrdbms_server_dnremote_os_authentresource_manager_cpu_allocationsec_case_sensitive_logonserial_reusesql_tracestandby_archive_destunified_audit_sga_queue_sizeuser_dump_destutl_file_dir26 rows selected.SQL>

0 0