Oracle | PRVT_TUNE

Oracle PRVT_TUNE_MVIEW Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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