[Home] [Help] [Dependency Information]
Object Name: | IEO_LNA_QUEUE_SPECIFIERS |
---|---|
Object Type: | TABLE |
Owner: | IEO |
Subobject Name: | |
Status: | VALID |
Queue specifiers are used to determine which logs or alerts go on which AQ queues. This is a different type of granularity than what AQ offers because some logs or alerts may be dropped entirely and never published. In such cases, we don't overfill the AQ and cause more scalability problems than are already present because of the potentially large volume of logs and alerts. In most cases, only the alerts are published to an AQ.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEO_LNA_QUEUE_SPECIFIERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ACTION_MAP
SEVERITY_MAP FACILITY_GUID ENABLE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FACILITY_GUID | VARCHAR2 | (32) | Yes | Specifies the FACILITY_GUID for this QUEUE_NAME. |
ACTION_MAP | NUMBER | (10) | Yes | Specifies the ACTION_MAP for this QUEUE_NAME. |
SEVERITY_MAP | NUMBER | (10) | Yes | Specifies the SEVERITY_MAP for this QUEUE_NAME. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
CREATION_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
QUEUE_NAME | VARCHAR2 | (512) | Yes | Specifies the AQ queue to publish to, given filter criteria. |
ENABLE | NUMBER | (1) | Yes | Indicates whether the queue specification is active/enabled or not. |
FACILITY_INSTANCE | VARCHAR2 | (512) | Specifies the FACILITY_INSTANCE for this QUEUE_NAME. | |
RESERVED | VARCHAR2 | (2000) | Reserved for on-site customization, etc. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
Cut, paste (and edit) the following text to query this object:
SELECT FACILITY_GUID
, ACTION_MAP
, SEVERITY_MAP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, QUEUE_NAME
, ENABLE
, FACILITY_INSTANCE
, RESERVED
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_LNA_QUEUE_SPECIFIERS;
IEO.IEO_LNA_QUEUE_SPECIFIERS does not reference any database object
IEO.IEO_LNA_QUEUE_SPECIFIERS is referenced by following:
|
|
|