Oracle 18cR3 DBMS_CUBE_ADVISE

Oracle DBMS_CUBE_ADVISE_SEC Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_CUBE_ADVICE_SEQ$

DBMS_CUBE_ADVISE

DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
ORA-08002	dbms_cube_advice_seq$.currval not yet defined in the session
ORA-20103	invalid cube name, SYS.TAB$

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/olap/admin/prvtcoas.plb

Subprograms

COADSEQ_CURRENT

COADSEQ_NEXT

COADSEQ_CURRENT

Undocumented dbms_cube_advise_sec.coadseq_current RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.coadseq_current

      FROM dual;

             *

      ERROR at line 1:

      ORA-08002: sequence DBMS_CUBE_ADVICE_SEQ$.CURRVAL is not yet defined in 
      this session

      ORA-06512: at "SYS.DBMS_CUBE_ADVISE_SEC", line 221

If you run coadseq_next first returns a "1"

COADSEQ_NEXT

Undocumented dbms_cube_advise_sec.coadseq_next RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.coadseq_next

      FROM dual;

      

      COADSEQ_NEXT

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

                 1