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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_PARALLEL
DBMS_HS_PASSTHROUGH
DBMS_HS_UTL
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx