Oracle | PRVT_SYS_TUNE

Oracle PRVT_SYS_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 DEFINER

Dependencies

DBMS_ASSERT	DBMS_SYS_ERROR	WRI$_ADV_ACTIONS
DBMS_LOB	DBMS_TUNEMV_LIB	WRI$_ADV_RECOMMENDATIONS
DBMS_SQL	DBMS_XRWMV	WRI$_ADV_REC_ACTIONS
DBMS_STANDARD	EXPLAINMVARRAYTYPE	WRI$_ADV_TASKS
DBMS_SYSTEM	PRVT_TUNE_MVIEW

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

ADVISE_MVIEW_LOG	DROP_SUB_MV	INTERNAL_EXPLAIN_MVIEW
ANALYZE_MVLOGS	DUMP_MVLOG_DDL	PROCESS_SINGLE_TOP_MV
CHECK_BUFFER_OVERFLOW	FINALIZE_TASK	RECORD_SUB_MV
CHECK_TUNED	INSERT_MESSAGE	TRACE_DEBUG
CREATE_SUB_MV	INSERT_REC_ACTION	UPDATE_SUB_MV
DELETE_REC_ACTIONS

ADVISE_MVIEW_LOG

Undocumented prvt_sys_tune_mview.advise_mview_log( tid_in IN BINARY_INTEGER, tid_out IN BINARY_INTEGER, mv_owner IN VARCHAR2, mv_name IN VARCHAR2, user_id IN BINARY_INTEGER, action_id IN OUT BINARY_INTEGER);

TBD

ANALYZE_MVLOGS

Undocumented prvt_sys_tune_mview.analyze_mvlogs( query IN CLOB, user_id IN BINARY_INTEGER, task_id IN BINARY_INTEGER, rec_id IN BINARY_INTEGER, action_id IN OUT BINARY_INTEGER);

TBD

CHECK_BUFFER_OVERFLOW

Undocumented prvt_sys_tune_mview.check_buffer_overflow( param_name IN VARCHAR2, param_value IN VARCHAR2, param_max_len IN BINARY_INTEGER);

TBD

CHECK_TUNED

Undocumented prvt_sys_tune_mview.check_tuned( task_id IN NUMBER, is_tuned OUT BOOLEAN, is_decomposed OUT BOOLEAN, max_aid OUT NUMBER);

TBD

CREATE_SUB_MV

Undocumented prvt_sys_tune_mview.create_sub_mv( tid_in IN NUMBER, mv_owner IN VARCHAR2, mv_name IN VARCHAR2, submv IN OUT VARCHAR2, cnt IN OUT NUMBER);

TBD

DELETE_REC_ACTIONS

Undocumented prvt_sys_tune_mview.delete_rec_actions( tid IN NUMBER, action_id IN NUMBER);

TBD

DROP_SUB_MV

Undocumented prvt_sys_tune_mview.drop_sub_mv(tid IN NUMBER);

TBD

DUMP_MVLOG_DDL

Undocumented prvt_sys_tune_mview.dump_mvlog_ddl(tid IN BINARY_INTEGER);

TBD

FINALIZE_TASK

Undocumented prvt_sys_tune_mview.finalize_task(tid IN NUMBER);

TBD

INSERT_MESSAGE

Undocumented

Overload 1 prvt_sys_tune_mview.insert_message( message IN VARCHAR2);

exec 
      prvt_sys_tune_mview.insert_message('Msg');

      

      PL/SQL procedure successfully completed.

Overload 2 prvt_sys_tune_mview.insert_message( message IN VARCHAR2, flag IN BOOLEAN);

exec prvt_sys_tune_mview.insert_message('Msg', TRUE);

      

      PL/SQL procedure successfully completed.

INSERT_REC_ACTION

Undocumented prvt_sys_tune_mview.insert_rec_action( aid IN NUMBER, rid IN NUMBER, tid IN NUMBER, cmd IN NUMBER, att1 IN VARCHAR2, att2 IN VARCHAR2, att3 IN VARCHAR2, att4 IN VARCHAR2, att5 IN CLOB, att6 IN CLOB, msgid IN NUMBER, oflags IN NUMBER);

TBD

INTERNAL_EXPLAIN_MVIEW

Undocumented prvt_sys_tune_mview.internal_explain_mview( mv_create_stmt IN VARCHAR2, xmv_array IN OUT sys.explainmvarraytype);

TBD

PROCESS_SINGLE_TOP_MV

Undocumented prvt_sys_tune_mview.process_single_top_mv( tid_in IN NUMBER, tid_out IN NUMBER, user_id IN NUMBER, mv_owner IN VARCHAR2, mv_name IN VARCHAR2, rf_txt IN VARCHAR2, rw_txt IN VARCHAR2, phy_attr IN CLOB, action_id IN OUT NUMBER, sel_stmt IN CLOB);

TBD

RECORD_SUB_MV

Undocumented prvt_sys_tune_mview.record_sub_mv( tid_in IN NUMBER, tid_out IN NUMBER, mv_owner IN VARCHAR2, mv_name IN VARCHAR2, rw_txt IN VARCHAR2, phy_attr IN CLOB, action_id IN OUT NUMBER);

TBD

TRACE_DEBUG

Undocumented prvt_sys_tune_mview.trace_debug RETURN BOOLEAN;

BEGIN

        IF prvt_sys_tune_mview.trace_debug THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

UPDATE_SUB_MV

Undocumented prvt_sys_tune_mview.update_sub_mv( tid_in IN NUMBER, sub_name IN VARCHAR2, comm_id IN NUMBER);

TBD