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


TABLE: SYS.DBMSHP_RUNS

Object Details
Object Name: DBMSHP_RUNS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Run-specific information for the hierarchical profiler

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00255293
  1. ColumnRUNID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00255293 NORMAL UNIQUE TablespaceSYSTEM ColumnRUNID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableDBMSHP_FUNCTION_INFO SYS_C00255295 DBMSHP_RUNS DBMSHP_FUNCTION_INFO RUNID
Columns
Name Datatype Length Mandatory Comments
RUNID NUMBER
Yes
RUN_TIMESTAMP TIMESTAMP(6) (11)
TOTAL_ELAPSED_TIME NUMBER

RUN_COMMENT VARCHAR2 (2047)
Query Text

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


SELECT RUNID
,      RUN_TIMESTAMP
,      TOTAL_ELAPSED_TIME
,      RUN_COMMENT
FROM SYS.DBMSHP_RUNS;

Dependencies

[top of page]

SYS.DBMSHP_RUNS does not reference any database object

SYS.DBMSHP_RUNS is not referenced by any database object