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

VIEW: SYS.DBMS_PARALLEL_EXECUTE_EXTENTS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
SEGMENT_NAME VARCHAR2 (128)
PARTITION_NAME VARCHAR2 (128)
SEGMENT_TYPE VARCHAR2 (18)
DATA_OBJECT_ID NUMBER

RELATIVE_FNO NUMBER

BLOCK_ID NUMBER

BLOCKS NUMBER

Query Text

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


SELECT OWNER
,      SEGMENT_NAME
,      PARTITION_NAME
,      SEGMENT_TYPE
,      DATA_OBJECT_ID
,      RELATIVE_FNO
,      BLOCK_ID
,      BLOCKS
FROM SYS.DBMS_PARALLEL_EXECUTE_EXTENTS;

Dependencies

[top of page]

SYS.DBMS_PARALLEL_EXECUTE_EXTENTS references the following:

SchemaSYS
TableFILE$
TableOBJ$
TableSEG$
TableTAB$
TableTABPART$
TableTABSUBPART$
TableTS$
TableUET$
TableUSER$

SYS.DBMS_PARALLEL_EXECUTE_EXTENTS is not referenced by any database object