Oracle | DBMS_HS_PARALLEL

Oracle DBMS_HS_PARALLEL_METADATA 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 Undocumented Heterogeneous Services Utility Package

AUTHID DEFINER

Data Types TYPE HvList IS TABLE OF VARCHAR2(5000); TYPE NumList IS TABLE OF NUMBER;

Dependencies

ANYDATA	DBMS_SCHEDULER	HSBLKVALARY
DBMS_ASSERT	DBMS_SYS_ERROR	PLITBLM
DBMS_HS_PARALLEL	HSBLKNAMLST

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmshsld.sql
{ORACLE_HOME}/rdbms/admin/prvthsld.plb

Subprograms

CHECK_CAP	LOADHISINFO	PURGEMETADATA
DELETE_VIEWOBJ	LOADINDCOLINFO	RAISE_SYSTEM_ERROR
GET_CPU_NUM	LOADPATITIONINFO	SCHEDULE_SAMPLING
GET_DOMAIN_NAME	LOAD_SAMPLEDATA	UPDATE_SAMPLEMETA
INSERT_VIEWOBJ

CHECK_CAP

Undocumented dbms_hs_parallel_metadata.check_cap( dblink IN VARCHAR2, cap_number IN NUMBER) RETURN BOOLEAN;

TBD

DELETE_VIEWOBJ

Undocumented dbms_hs_parallel_metadata.delete_viewobj( ora_view_schema IN VARCHAR2, ora_view_name IN VARCHAR2);

TBD

GET_CPU_NUM

Imprecisely named ... returns the number of cpu cores dbms_hs_parallel_metadata.get_cpu_num RETURN INTEGER;

SELECT dbms_hs_parallel_metadata.get_cpu_num

      FROM dual;

      

      GET_CPU_NUM

      -----------

                4

GET_DOMAIN_NAME

Undocumented dbms_hs_parallel_metadata.get_domain_name RETURN VARCHAR2;

TBD

INSERT_VIEWOBJ

Undocumented dbms_hs_parallel_metadata.insert_viewobj( ora_view_schema IN VARCHAR2, oraview_name IN VARCHAR2, hsbkseq IN NUMBER);

TBD

LOADHISINFO

Undocumented dbms_hs_parallel_metadata.loadHisinfo( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2, ind_available IN BOOLEAN, numBucket IN NUMBER, part_column IN VARCHAR2, part_col_type IN VARCHAR2, p_col_names IN HSBLKNamLst, p_col_types IN HSBLKNamLst, hisValues IN NumList, col_names IN HSBLKNamLst, col_types IN HSBLKNamLst, parallel_degree IN INTEGER);

TBD

LOADINDCOLINFO

Undocumented dbms_hs_parallel_metadata.loadIndColinfo( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2, ind_available IN BOOLEAN, max_val IN NUMBER, min_val IN NUMBER, avg_val IN NUMBER, part_column IN VARCHAR2, part_col_type IN VARCHAR2, p_col_names IN HSBLKNamLst, p_col_types IN HSBLKNamLst, col_names IN HSBLKNamLst, col_types IN HSBLKNamLst, parallel_degree IN INTEGER);

TBD

LOADPATITIONINFO

Undocumented dbms_hs_parallel_metadata.loadPatitioninfo( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2, p_cnt IN NUMBER, p_key_cols IN HSBLKNamLst, p_key_cnt IN NUMBER, typlst IN HSBLKNamLst, hvalueList IN HvList, hvalLen IN NumList, partPos IN NumList, parallel_degree IN INTEGER);

TBD

LOAD_SAMPLEDATA

Undocumented dbms_hs_parallel_metadata.load_sampledata( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2, low_value IN VARCHAR2, high_value IN VARCHAR2, position IN INTEGER);

TBD

PURGEMETADATA

Undocumented dbms_hs_parallel_metadata.purgemetadata( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2);

TBD

RAISE_SYSTEM_ERROR

Undocumented dbms_hs_parallel_metadata.raise_system_error( error_number IN INTEGER, arg1 IN VARCHAR2);

TBD

SCHEDULE_SAMPLING

Undocumented dbms_hs_parallel_metadata.schedule_sampling( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, database_link IN VARCHAR2, hs_remote_tab_typ IN VARCHAR2, p_degree IN INTEGER, row_count IN NUMBER, ora_user IN VARCHAR2, oracle_table_name IN VARCHAR2, pt_col_names IN HSBLKNamLst, pt_col_types IN HSBLKNamLst, col_names IN HSBLKNamLst, col_types IN HSBLKNamLst);

TBD

UPDATE_SAMPLEMETA

Undocumented dbms_hs_parallel_metadata.update_samplemeta( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, dblink IN VARCHAR2, parallel_degree IN INTEGER, sample_column IN VARCHAR2, sample_column_type IN VARCHAR2);

TBD