Oracle DBMS_UMF_PROTECTED
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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_LIB
DBMS_ASH_INTERNAL DBMS_STANDARD DBMS_WORKLOAD_REPOSITORY
DBMS_AWR_REPORT_LAYOUT DBMS_SWRF_REPORT_INTERNAL PLITBLM
DBMS_LOB DBMS_UMF_INTERNAL  
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvsumfi.plb
Subprograms
PSF_ADD_BIND PSF_GET_DEFINE PSF_INIT_DEFINES
PSF_DEFINE_COLUMNS PSF_GET_ENV_FLAG_BY_DBID PSF_SUBSTITUTE_PAT
PSF_EXECUTE_QUERY PSF_INIT_BINDS PSF_TRANSFORM_VCHAR
 
PSF_ADD_BIND (new 12.2)
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);
TBD
Overload 2 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     awrrpt_instance_list_type,
binds      IN OUT dbms_umf_protected.umf_binds_type);
TBD
Overload 3 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     VARCHAR2,
binds      IN OUT dbms_umf_protected.umf_binds_type);
TBD
Overload 4 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     TIMESTAMP,
binds      IN OUT dbms_umf_protected.umf_binds_type);
TBD
Overload 5 dbms_umf_protected.psf_add_bind(
bind_type  IN BINARY_INTEGER,
bind_value IN     dbms_umf_protected.numberpsf_num_array_type,
binds      IN OUT dbms_umf_protected.umf_binds_type);
TBD
Overload 6 dbms_umf_protected.psf_add_bind(
bind_type  IN     BINARY_INTEGER,
bind_value IN     DATE,
binds      IN OUT dbms_umf_protected.umf_binds_type);
TBD
 
PSF_DEFINE_COLUMNS (new 12.2)
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);
TBD
 
PSF_EXECUTE_QUERY (new 12.2)
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;
TBD
 
PSF_GET_DEFINE (new 12.2)
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);
TBD
Overload 2 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT VARCHAR2);
TBD
Overload 3 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT TIMESTAMP);
TBD
Overload 4 dbms_umf_protected.psf_get_define(
defs IN     dbms_umf_protected.psf_defines_type,
idx  IN     BINARY_INTEGER,
var  IN OUT DATE);
TBD
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);
TBD
 
PSF_GET_ENV_FLAG_BY_DBID (new 12.2)
Undocumented dbms_umf_protected.psf_get_env_flag_by_dbid(
l_dbid IN NUMBER)
RETURN BINARY_INTEGER;
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_INIT_BINDS (new 12.2)
Undocumented dbms_umf_protected.psf_init_binds(binds IN OUT dbms_umf_protected.psf_binds_type);
TBD
 
PSF_UMF_DEFINES (new 12.2)
Undocumented dbms_umf_protected.psf_umf_defines(defs IN OUT dbms_umf_protected.psf_defines_type);
TBD
 
PSF_SUBSTITUTE_PAT (new 12.2)
Undocumented dbms_umf_protected.psf_substitute_pat(
sql_str_in_clob IN     CLOB,
sql_str_out     IN OUT CLOB,
env_flag        IN     BINARY_INTEGER);
TBD
 
PSF_TRANSFORM_VCHAR (new 12.2)
Undocumented dbms_umf_protected.psf_transform_vchar(
str      IN OUT VARCHAR2,
max_len  IN     NUMBER,
env_flag IN     BINARY_INTEGER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_UMF
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved