Oracle19c无法连接指定的,Oracle 19C 无法启用Auto Indexes特性

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

;

2 在启用Automatic Indexing

时报如下错误，不支持该特性：

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

可以看下面的链接：

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"，共同学习，共同成长！！！