DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.HS_PARALLEL_METADATA

Object Details
Object Name: HS_PARALLEL_METADATA
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DBLINK VARCHAR2 (128) Yes
REMOTE_TABLE_NAME VARCHAR2 (128) Yes
REMOTE_SCHEMA_NAME VARCHAR2 (128) Yes
PARALLEL VARCHAR2 (1) Yes
PARALLEL_DEGREE NUMBER (38) Yes
RANGE_PARTITIONED VARCHAR2 (1) Yes
SAMPLED VARCHAR2 (1) Yes
HISTOGRAM VARCHAR2 (1) Yes
IND_AVAILABLE VARCHAR2 (1) Yes
SAMPLE_CAP VARCHAR2 (1) Yes
HIST_COLUMN VARCHAR2 (128)
HIST_COLUMN_TYPE VARCHAR2 (128)
SAMPLE_COLUMN VARCHAR2 (128)
SAMPLE_COLUMN_TYPE VARCHAR2 (128)
NUM_PARTITIONS NUMBER (38)
NUM_PARTITION_COLUMNS NUMBER (38)
PARTITION_COL_NAMES HSBLKNAMLST (64)
PARTITION_COL_TYPES HSBLKNAMLST (64)
NCOL_MIN_VAL NUMBER

NCOL_AVG_VAL NUMBER

NCOL_MAX_VAL NUMBER

NUM_BUCKETS NUMBER (38)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DBLINK
,      REMOTE_TABLE_NAME
,      REMOTE_SCHEMA_NAME
,      PARALLEL
,      PARALLEL_DEGREE
,      RANGE_PARTITIONED
,      SAMPLED
,      HISTOGRAM
,      IND_AVAILABLE
,      SAMPLE_CAP
,      HIST_COLUMN
,      HIST_COLUMN_TYPE
,      SAMPLE_COLUMN
,      SAMPLE_COLUMN_TYPE
,      NUM_PARTITIONS
,      NUM_PARTITION_COLUMNS
,      PARTITION_COL_NAMES
,      PARTITION_COL_TYPES
,      NCOL_MIN_VAL
,      NCOL_AVG_VAL
,      NCOL_MAX_VAL
,      NUM_BUCKETS
FROM SYS.HS_PARALLEL_METADATA;

Dependencies

[top of page]

SYS.HS_PARALLEL_METADATA references the following:

SchemaSYS
TableHS$_PARALLEL_METADATA
TYPEHSBLKNAMLST
PL/SQL PackageSTANDARD - show dependent code
SYS.HS_PARALLEL_METADATA is referenced by following:

SchemaPUBLIC
SynonymHS_PARALLEL_METADATA