Oracle PRVT_TUNE_MVIEW
Version 20c

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 Utilitiy package with objects supporting DBMS_ADVISOR.TUNE_MVIEW

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_ADVISOR
DBMS_HETEROGENEOUS_SNAPSHOT
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
What's New In 19c
What's New In 20c

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