Oracle | DBMS_AUTO_CLUSTERING

Oracle DBMS_AUTO_CLUSTERING_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal support utilities with subprograms called by DBMS_AUTO_CLUSTERING for creation of automatic clustering.

Run this package to create clustering recommendations based on workload running in the system. Also run this package to verify and implement the clustering recommendations. This package contains subprograms that display a report of the task, configure the execution and behavior of task.

AUTHID DEFINER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_AUTO_CLUSTERING_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_AUTO_CLUSTERING_INTERNAL' ORDER BY 1;

Returns 65 objects

Documented No

First Available 23ai

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsaci.plb
{ORACLE_HOME}/rdbms/admin/prvtaci.plb

Subprograms

AC_CLEAR	CONFIGURE	RECOMMEND_CLUSTERING_METHOD
AC_INIT	GET_RECOMMENDATION	REPORT_ACTIVITY
AC_TASK_PROC	GET_REPORT_LEVELS	VERIFY_RECOMMENDATION
APPLY_RECOMMENDATION	GET_REPORT_SECTIONS

AC_CLEAR (new 23ai)

Undocumented dbms_auto_clustering_internal.ac_clear;

exec dbms_auto_clustering_internal.ac_clear;

      

      PL/SQL procedure successfully completed.

AC_INIT (new 23ai)

Undocumented dbms_auto_clustering_internal.ac_init;

exec dbms_auto_clustering_internal.ac_init;

      

      PL/SQL procedure successfully completed.

AC_TASK_PROC (new 23ai)

Undocumented dbms_auto_clustering_internal.ac_task_proc( stsowner IN VARCHAR2, stsname IN VARCHAR2, task_start_time IN TIMESTAMP, task_end_time IN TIMESTAMP);

TBD

APPLY_RECOMMENDATION (new 23ai)

Undocumented dbms_auto_clustering_internal.apply_recommendation( recommendation_id IN RAW, table_owner IN VARCHAR2, table_name IN VARCHAR2, clustering_ddl IN VARCHAR2, apply_mode IN VARCHAR2);

TBD

CONFIGURE (new 23ai)

Undocumented dbms_auto_clustering_internal.configure( parameter_name IN VARCHAR2, parameter_value IN VARCHAR2, allow IN BOOLEAN);

TBD

GET_RECOMMENDATION (new 23ai)

Undocumented dbms_auto_clustering_internal.get_recommendation( table_owner IN VARCHAR2, table_name IN VARCHAR2) RETURN RAW;

SELECT dbms_auto_clustering_internal.get_recommendation('C##UWCLASS', 'ACTABLE');

      

      ORA-40216: Feature not supported in 23.1 through 23.8

GET_REPORT_LEVELS (new 23ai)

Undocumented dbms_auto_clustering_internal.get_report_levels(report_level IN VARCHAR2) RETURN NUMBER;

SELECT dbms_auto_clustering_internal.get_report_levels('TYPICAL');

      

      DBMS_AUTO_CLUSTERING_INTERNAL.GET_REPORT_LEVELS('TYPICAL')

      ----------------------------------------------------------

                                                               1

      

      SELECT dbms_auto_clustering_internal.get_report_levels('BASIC');

      

      
      DBMS_AUTO_CLUSTERING_INTERNAL.GET_REPORT_LEVELS('BASIC')

      --------------------------------------------------------

                                                             2

      

      SELECT dbms_auto_clustering_internal.get_report_levels('ALL');

      

      
      DBMS_AUTO_CLUSTERING_INTERNAL.GET_REPORT_LEVELS('ALL')

      ------------------------------------------------------

                                                           4

GET_REPORT_SECTIONS (new 23ai)

Undocumented dbms_auto_clustering_internal.get_report_sections(report_section IN VARCHAR2) RETURN NUMBER;

SELECT 
      dbms_auto_clustering_internal.get_report_sections('SUMMARY');

      

      
      DBMS_AUTO_CLUSTERING_INTERNAL.GET_REPORT_SECTIONS('SUMMARY')

      ------------------------------------------------------------

                                                                33

      

      SELECT 
      dbms_auto_clustering_internal.get_report_sections('ALL');

      

      
      DBMS_AUTO_CLUSTERING_INTERNAL.GET_REPORT_SECTIONS('ALL')

      --------------------------------------------------------

                                                            63

RECOMMEND_CLUSTERING_METHOD (new 23ai)

Undocumented dbms_auto_clustering_internal.recommend_clustering_method( sqlset_owner IN VARCHAR2, sqlset_name IN VARCHAR2, table_owner IN VARCHAR2, table_name IN VARCHAR2, time_limit IN INTERVAL DAY TO SECOND, report_type IN VARCHAR2, report_section IN VARCHAR2, report_level IN VARCHAR2, verification IN BOOLEAN);

TBD

REPORT_ACTIVITY (new 23ai)

Undocumented dbms_auto_clustering_internal.retport_activity( activity_start IN TIMESTAMP WITH TIME ZONE, activity_end IN TIMESTAMP WITH TIME ZONE, section_flags IN NUMBER, level_flags IN NUMBER, RETURN sys.xmlType;

TBD

VERIFY_RECOMMENDATION (new 23ai)

Undocumented dbms_auto_clustering_internal.verify_recommendation( recommendation_id IN RAW, table_owner IN VARCHAR2, table_name IN VARCHAR2);

TBD