[Home] [Help] [Dependency Information]
Object Name: | SYS$SERVICE_METRICS_TAB |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00246433 | NORMAL | UNIQUE | SYSAUX | MSGID |
SYS_IL0000629904C00031$$ | LOB | UNIQUE | SYSAUX |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
Q_NAME | VARCHAR2 | (30) | ||
MSGID | RAW | (16) | Yes | |
CORRID | VARCHAR2 | (128) | ||
PRIORITY | NUMBER | |||
STATE | NUMBER | |||
DELAY | TIMESTAMP(6) | (11) | ||
EXPIRATION | NUMBER | |||
TIME_MANAGER_INFO | TIMESTAMP(6) | (11) | ||
LOCAL_ORDER_NO | NUMBER | |||
CHAIN_NO | NUMBER | |||
CSCN | NUMBER | |||
DSCN | NUMBER | |||
ENQ_TIME | TIMESTAMP(6) | (11) | ||
ENQ_UID | VARCHAR2 | (30) | ||
ENQ_TID | VARCHAR2 | (30) | ||
DEQ_TIME | TIMESTAMP(6) | (11) | ||
DEQ_UID | VARCHAR2 | (30) | ||
DEQ_TID | VARCHAR2 | (30) | ||
RETRY_COUNT | NUMBER | |||
EXCEPTION_QSCHEMA | VARCHAR2 | (30) | ||
EXCEPTION_QUEUE | VARCHAR2 | (30) | ||
STEP_NO | NUMBER | |||
RECIPIENT_KEY | NUMBER | |||
DEQUEUE_MSGID | RAW | (16) | ||
SENDER_NAME | VARCHAR2 | (30) | ||
SENDER_ADDRESS | VARCHAR2 | (1024) | ||
SENDER_PROTOCOL | NUMBER | |||
USER_DATA | SYS$RLBTYP | (1) | ||
USER_PROP | ANYDATA | (3748) |
Cut, paste (and edit) the following text to query this object:
SELECT Q_NAME
, MSGID
, CORRID
, PRIORITY
, STATE
, DELAY
, EXPIRATION
, TIME_MANAGER_INFO
, LOCAL_ORDER_NO
, CHAIN_NO
, CSCN
, DSCN
, ENQ_TIME
, ENQ_UID
, ENQ_TID
, DEQ_TIME
, DEQ_UID
, DEQ_TID
, RETRY_COUNT
, EXCEPTION_QSCHEMA
, EXCEPTION_QUEUE
, STEP_NO
, RECIPIENT_KEY
, DEQUEUE_MSGID
, SENDER_NAME
, SENDER_ADDRESS
, SENDER_PROTOCOL
, USER_DATA
, USER_PROP
FROM SYS.SYS$SERVICE_METRICS_TAB;
|
|
|