Oracle | PRVT_TUNE

Oracle PRVT_TUNE_MVIEW Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Utility package with objects supporting DBMS_ADVISOR.TUNE_MVIEW

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBMS_STANDARD	EXPLAINMVMESSAGE
DBMS_ADVISOR	DBMS_SYSTEM	PLITBLM
DBMS_ASSERT	DBMS_TUNEMV_LIB	PRVT_ACCESS_ADVISOR
DBMS_LOB	DBMS_XRWMV	PRVT_ADVISOR
DBMS_SQL	EXPLAINMVARRAYTYPE	PRVT_SYS_TUNE_MVIEW

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsms.plb

Subprograms

GENERATE_CHECKSUM	TUNE_MVIEW	VALIDATE_TUNE_MVIEW
SETUP_PARAMETERS

GENERATE_CHECKSUM

Compares two clobs and generates a checksum specific to the difference prvt_tune_mview.generate_checksum( src_stmt IN CLOB dest_stmt IN CLOB) RETURN BINARY_INTEGER;

DECLARE

       src    CLOB := 'Dan Morgan';

       dst    CLOB := 'Dan Morgan';

       retVal PLS_INTEGER;

      BEGIN

        retVal := prvt_tune_mview.generate_checksum(src, dst);

        dbms_output.put_line(retVal);

      END;

      /

      0

      

      PL/SQL procedure successfully completed.

      

      DECLARE

       src    CLOB := 'Dan Morgan';

       dst    CLOB := 'Dan  Morgan'; -- contains extra space

       retVal PLS_INTEGER;

      BEGIN

        retVal := prvt_tune_mview.generate_checksum(src, dst);

        dbms_output.put_line(retVal);

      END;

      /

      740093619

      

      PL/SQL procedure successfully completed.

SETUP_PARAMETERS

Undocumented prvt_tune_mview.setup_parameters;

exec prvt_tune_mview.setup_parameters;

TUNE_MVIEW

Called by the DBMS_ADVISOR TUNE_MVIEW procedure prvt_tune_mview.tune_mview( task_name IN OUT VARCHAR2, mv_create_stmt IN CLOB);

Follow the DBMS_ADVISOR link at page bottom

VALIDATE_TUNE_MVIEW

Undocumented prvt_tune_mview.validate_tune_mview( mv_crate_stmt IN CLOB, xmv_array OUT VARRAY, mvowner OUT VARCHAR2, mvname OUT VARCHAR2, mvname_pos OUT BINARY_INTEGER, refresh_pos OUT BINARY_INTEGER, as_pos OUT BINARY_INTEGER, refresh_type OUT BINARY_INTEGER, mv_flags OUT BINARY_INTEGER, text_match_only OUT BOOLEAN, complete_ref OUT BOOLEAN, already_fr OUT BOOLEAN, already_rw OUT BOOLEAN, tuneable OUT BOOLEAN, is_single_qb OUT BOOLEAN, has_like OUT BOOLEAN, check_mvlog IN BOOLEAN, mlog_only OUT BOOLEAN, REASON_BUF IN OUT VARCHAR2);

TBD