Oracle DBMS_UMF_PROTECTED
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Universal Message Format, UMF, Provides an interface for deploying the Remote Management Framework (RMF) for an Oracle Database. The RMF is used for collecting Oracle Database performance statistics. It provides functions to create and manage UMF topologies. Specifically, it provides calls to create/drop topologies and to modify a topology by adding/removing nodes and links. It also provides calls to manage services (such as AWR) running on nodes and to view/validate a topology. API calls for a given topology must be executed on the target for that topology. This is an internal package supporting DBMS_UMF.
AUTHID DEFINER
Data Types TYPE psf_binds_type ...

TYPE psf_defines_type ...

TYPE numberpsf_num_array_type ...

TYPE umf_finds_type ...
Dependencies
AWRRPT_INSTANCE_LIST_TYPE DBMS_SQL DBMS_UMF_INTERNAL
AWRRPT_NUMBER_LIST_TYPE DBMS_STANDARD DBMS_UMF_LIB
DBMS_ASH_INTERNAL DBMS_SWRF_REPORT_INTERNAL DBMS_WORKLOAD_REPOSITORY
DBMS_AWR_REPORT_LAYOUT DBMS_SYSTEM PLITBLM
DBMS_LOB    
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.

This object is protected by an ACCESSIBLE BY clause so no working demos are possible.
Source {ORACLE_HOME}/rdbms/admin/prvsumfi.plb
Subprograms
 
PSF_ADD_BIND (new 18c overload)
Undocumented

Overload 1
dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     NUMBER,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 2 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     sys.awrrpt_instance_list_type,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 3 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     sys.awrrpt_number_list_type,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 4 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     VARCHAR2,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 5 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     TIMESTAMP,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 6 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     dbms_umf_protected.psf_num_array_type,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
Overload 7 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     DATE,
binds      IN OUT dbms_umf_protected.umf_binds_type);
Protected by ACCESSIBLE BY Clause
 
PSF_CQCX_FINALIZE (new 18c)
Undocumented dbms_umf_protected.psf_cqcx_finalize(psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type);
Protected by ACCESSIBLE BY Clause
 
PSF_CQCX_INIT (new 18c)
Undocumented dbms_umf_protected.psf_cqcx_init(
psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type,
str_in   IN     CLOB,
evn_flag IN     BINARY_INTEGER,
icx_coll IN     sys.dbms_umf_protected.psf_icxc_type); 
Protected by ACCESSIBLE BY Clause
 
PSF_CREATE_INSTANTIATION_PAT (new 18c)
Undocumented dbms_umf_protected.psf_create_instantiation_pat(iid IN BINARY_INTEGER)
RETURN VARCHAR2;
Protected by ACCESSIBLE BY Clause
 
PSF_DEFINE_COLUMNS
Undocumented dbms_umf_protected.psf_define_columns(
defs   IN OUT dbms_umf_protected.psf_define_type,
offset IN     BINARY_INTEGER,
amount IN     BINARY_INTEGER,
dtype  IN     BINARY_INTEGER);
Protected by ACCESSIBLE BY Clause
 
PSF_EXECUTE_QUERY
Undocumented dbms_umf_protected.psf_execute_query(
cursor_str_in IN     CLOB,
query_type    IN     BINARY_INTEGER,
defs          IN OUT dbms_umf_protected.psf_defines_type,
binds         IN     dbms_umf_protected.psf_binds_type,
env_flag      IN     BINARY_INTEGER)
RETURN NUMBER;
Protected by ACCESSIBLE BY Clause
 
PSF_GET_DEFINE
Undocumented

Overload 1
dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT NUMBER);
Protected by ACCESSIBLE BY Clause
Overload 2 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT VARCHAR2);
Protected by ACCESSIBLE BY Clause
Overload 3 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT TIMESTAMP);
Protected by ACCESSIBLE BY Clause
Overload 4 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT DATE);
Protected by ACCESSIBLE BY Clause
Overload 5 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT awrrpt_instance_list_type);
Protected by ACCESSIBLE BY Clause
 
PSF_GET_ENV_FLAG_BY_DBID
Undocumented dbms_umf_protected.psf_get_env_flag_by_dbid(
l_dbid IN NUMBER)
RETURN BINARY_INTEGER;
Protected by ACCESSIBLE BY clause as demonstrated here.

SQL> SELECT dbid FROM v$database;

      DBID
----------
 768045447

SQL> SELECT dbms_umf_protected.psf_get_env_flag_by_dbid(768045447)
  2  FROM dual;
SELECT dbms_umf_protected.psf_get_env_flag_by_dbid(768045447)
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object DBMS_UMF_PROTECTED


SQL> sho user
USER is "SYS"

SQL> sho con_id

 CON_ID
-------
      1
 
PSF_ICXC_INIT (new 18c)
Undocumented dbms_umf_protected.psf_icxc_init(icx_coll IN OUT sys.dbms_umf_protected.psf_icxc_type);
Protected by ACCESSIBLE BY Clause
 
PSF_ICXC_SET (new 18c)
Undocumented dbms_umf_protected.psf_icxc_set(
icx_coll    IN OUT sys.dbms_umf_protected.psf_icxc_type,
iid         IN     BINARY_INTEGER,
ds_ver_type IN     BINARY_INTEGER);
Protected by ACCESSIBLE BY Clause
 
PSF_INIT_BINDS
Undocumented dbms_umf_protected.psf_init_binds(binds IN OUT dbms_umf_protected.psf_binds_type);
Protected by ACCESSIBLE BY Clause
 
PSF_UMF_DEFINES
Undocumented dbms_umf_protected.psf_umf_defines(defs IN OUT dbms_umf_protected.psf_defines_type);
Protected by ACCESSIBLE BY Clause
 
PSF_SUBSTITUTE_PAT
Undocumented dbms_umf_protected.psf_substitute_pat(
sql_str_in_clob IN     CLOB,
sql_str_out     IN OUT CLOB,
env_flag        IN     BINARY_INTEGER);
Protected by ACCESSIBLE BY Clause
 
PSF_SUBSTITUTE_PAT2 (new 18c)
Undocumented dbms_umf_protected.psf_substitute_pat2(psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type);
Protected by ACCESSIBLE BY Clause
 
PSF_TRANSFORM_VCHAR
Undocumented dbms_umf_protected.psf_transform_vchar(
str      IN OUT VARCHAR2,
max_len  IN     NUMBER,
env_flag IN     BINARY_INTEGER);
Protected by ACCESSIBLE BY Clause

Related Topics
Built-in Functions
Built-in Packages
DBMS_UMF
DBMS_UMF_INTERNAL
What's New In 18cR3
What's New In 19cR2

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