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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_MVIEW
DBMS_MVIEW_STATS
DBMS_MVIEW_STATS_INTERNAL
DBMS_REFRESH
DBMS_SNAPSHOT_COMMON
DBMS_SNAPSHOT_KKXRCA
DBMS_SNAPSHOT_UTL
DBMS_SNAP_REPAPI
Materialized Views
PRVT_TUNE_MVIEW
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx