[Home] [Help] [Dependency Information]
Object Name: | DBA_STREAMS_TP_PATH_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Path Statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATH_ID | NUMBER | ID of the Streams Path | ||
STATISTIC_TIME | DATE | Time That the Statistic Was Taken | ||
STATISTIC_NAME | VARCHAR2 | (64) | Name of the Statistic | |
STATISTIC_VALUE | NUMBER | Value of the Statistic | ||
STATISTIC_UNIT | VARCHAR2 | (64) | Unit of the Statistic | |
ADVISOR_RUN_ID | NUMBER | 1-based Logical Number of Advisor Run | ||
ADVISOR_RUN_TIME | DATE | Time That the Advisor Was Run |
Cut, paste (and edit) the following text to query this object:
SELECT PATH_ID
, STATISTIC_TIME
, STATISTIC_NAME
, STATISTIC_VALUE
, STATISTIC_UNIT
, ADVISOR_RUN_ID
, ADVISOR_RUN_TIME
FROM SYS.DBA_STREAMS_TP_PATH_STAT;
|
|
|