温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Oracle 19C 无法启用Auto Indexes特性

发布时间:2020-08-18 22:49:50 阅读:280 作者:chenoracle 栏目:关系型数据库
开发者测试专用服务器限时活动,0元免费领,库存有限,领完即止! 点击查看>>

Oracle 19C 无法启用Auto Indexes特性

环境:

OS:Red Hat Enterprise Linux Server release 7.5 (Maipo)

DB:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

说明:

近期查看Oracle 19C新特性,发现Auto Indexes特性特别实用,想看看效果;

1 查看auto_index特性未启用;

SQL> select   *   from  dba_auto_index_config ;

Oracle 19C 无法启用Auto Indexes特性

2 在启用Automatic Indexing 时报如下错误,不支持该特性:

Oracle 19C 无法启用Auto Indexes特性

SQL> alter session set container=cjcpdb;

SQL> EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');

BEGIN DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT'); END;

*

ERROR at line 1:

ORA-40216: feature not supported

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: at "SYS.DBMS_AUTO_INDEX_INTERNAL", line 9180

ORA-06512: at "SYS.DBMS_AUTO_INDEX", line 283

ORA-06512: at line 1

问题原因:

只有在 EXADATA systems 系统下才支持 Auto Index 特性。

Auto indexing will be allowed only in EXADATA systems, if not it will raise ORA-40216: feature not supported when we try it turn it on in non exadata systems.

ORA-40216 When Using Auto Index Feature (Doc ID 2570076.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later Information in this document applies to any platform.

SYMPTOMS

When attempting to use auto index feature ,e.g. DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT'); it reports

ORA-40216: feature not supported ORA-6512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-6512: at "SYS.DBMS_AUTO_INDEX_INTERNAL", line 9180 ORA-6512: at "SYS.DBMS_AUTO_INDEX", line 283 ORA-6512: at line 1

CHANGES

CAUSE

This issue has been discussed in

Bug 30017206 : ADW : AUTO INDEX FEATURE NOT WORKING IN FUTURE PRODUCTION

Closed as 'Not a Bug.' Development explains: Auto indexing will be allowed only in EXADATA systems, if not it will raise ORA-40216: feature not supported when we try it turn it on in non exadata systems.  

SOLUTION

Do not use AUTO INDEX FEATURE in non-exadata systems.

想学习 AUTO INDEX FEATURE 可以看下面的链接:

https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-D1285CD5-95C0-4E74-8F26-A02018EA7999

Database Administrator’s Guide --- 21 Managing Indexes

21.7 Managing Auto Indexes

You can use the automatic indexing feature to configure and use auto indexes in an Oracle database to improve database performance.

......

欢迎关注我的微信公众号"IT小Chen",共同学习,共同成长!!!

Oracle 19C 无法启用Auto Indexes特性

Oracle 19C 无法启用Auto Indexes特性


亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

原文链接:http://blog.itpub.net/29785807/viewspace-2674601/

AI

开发者交流群×