[Home] [Help] [Dependency Information]
Object Name: | PRVT_AWR_PERIOD |
---|---|
Object Type: | TYPE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
M_TYPE | VARCHAR2 | (10) | |
M_DBID | INTEGER |
|
|
M_BEGIN_SNAP_ID | INTEGER |
|
|
M_END_SNAP_ID | INTEGER |
|
|
M_REQ_ANALYSIS | VARCHAR2 | (10) | |
M_ACTUAL_ANALYSIS | VARCHAR2 | (10) | |
M_INSTANCE_LIST | VARCHAR2 | (512) | |
M_INSTANCES | PRVT_AWR_INST_META_TAB |
|
|
M_DB_VERSION | VARCHAR2 | (17) | |
M_AWR_VERSION | VARCHAR2 | (17) | |
M_DB_NAME | VARCHAR2 | (9) | |
M_BEGIN_TIME | DATE |
|
|
M_END_TIME | DATE |
|
|
M_SNAPSHOT_INTR | NUMBER |
|
|
M_DB_TIME | NUMBER |
|
|
M_ASH_ROW_CNT | INTEGER |
|
|
M_WRR_METADATA | XMLTYPE |
|
|
M_IS_IMPORTED | INTEGER |
|
|
M_ERROR_XML | XMLTYPE |
|
|
M_WARNING_XML | XMLTYPE |
|
Name | Parameters | Result |
---|---|---|
PRVT_AWR_PERIOD |
SELF(PRVT_AWR_PERIOD) P_DBID(INTEGER) P_BEGIN_SNAP_ID(INTEGER) P_END_SNAP_ID(INTEGER) P_INSTANCE_NUMBER(INTEGER) P_TYPE(VARCHAR2) |
PRVT_AWR_PERIOD |
TO_XML |
SELF(PRVT_AWR_PERIOD) |
XMLTYPE |
GET_INST_CLAUSE |
SELF(PRVT_AWR_PERIOD) P_TABLE_NAME(VARCHAR2) |
VARCHAR2 |
GET_TIME_PER_ROW |
SELF(PRVT_AWR_PERIOD) |
NUMBER |
GET_ROW_CNT |
SELF(PRVT_AWR_PERIOD) P_DBTIME(NUMBER) P_DEFAULT(NUMBER) |
NUMBER |
|
|
|