[Home] [Help] [Dependency Information]
Object Name: | PLSQL_PROFILER_UNITS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information about each library unit in a run
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00255288 | NORMAL | UNIQUE | SYSTEM |
RUNID
UNIT_NUMBER |
Table | |
Foreign Table | Foreign Key Column | PLSQL_PROFILER_UNITS | PLSQL_PROFILER_RUNS | PLSQL_PROFILER_UNITS RUNID | PLSQL_PROFILER_DATA | PLSQL_PROFILER_UNITS |
PLSQL_PROFILER_DATA
RUNID
PLSQL_PROFILER_DATA UNIT_NUMBER |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUNID | NUMBER | Yes | ||
UNIT_NUMBER | NUMBER | Yes | ||
UNIT_TYPE | VARCHAR2 | (32) | ||
UNIT_OWNER | VARCHAR2 | (32) | ||
UNIT_NAME | VARCHAR2 | (32) | ||
UNIT_TIMESTAMP | DATE | |||
TOTAL_TIME | NUMBER | Yes | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RUNID
, UNIT_NUMBER
, UNIT_TYPE
, UNIT_OWNER
, UNIT_NAME
, UNIT_TIMESTAMP
, TOTAL_TIME
, SPARE1
, SPARE2
FROM SYS.PLSQL_PROFILER_UNITS;
SYS.PLSQL_PROFILER_UNITS does not reference any database object
SYS.PLSQL_PROFILER_UNITS is referenced by following:
|
|
|