[Home] [Help] [Dependency Information]
Object Name: | FND_LOG_METRICS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOG_METRICS |
Subobject Name: | |
Status: | VALID |
This new table will store logged metrics
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOG_METRICS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CONTEXT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
METRIC_SEQUENCE | NUMBER | Yes | Primary key | |
MODULE | VARCHAR2 | (255) | Yes | Name of module that logged the metric |
METRIC_CODE | VARCHAR2 | (60) | Yes | Internal name of the metric |
TYPE | VARCHAR2 | (1) | Yes | String, Number, Date |
STRING_VALUE | VARCHAR2 | (2000) | Value if metric is a string | |
NUMBER_VALUE | NUMBER | Value if metric is a number | ||
DATE_VALUE | DATE | Value if metric is a date | ||
AUDSID | NUMBER | Yes | AUDSID of DB session that reported the metric | |
DB_INSTANCE | NUMBER | Yes | Number of the database instance through which the metric was reported | |
TIME | DATE | Yes | Time that the metric was recorded | |
EVENT_KEY | VARCHAR2 | (240) | Null until metric has been posted in a Business Event | |
TRANSACTION_CONTEXT_ID | NUMBER | Foreign key into fnd_log_transaction_context. Points to details of the transaction that logged this message | ||
SESSION_MODULE | VARCHAR2 | (48) | v$session.module | |
SESSION_ACTION | VARCHAR2 | (32) | v$session.action | |
NODE | VARCHAR2 | (60) | Host name | |
NODE_IP_ADDRESS | VARCHAR2 | (30) | Host IP address | |
PROCESS_ID | VARCHAR2 | (120) | OS Process ID | |
JVM_ID | VARCHAR2 | (120) | Internal Identifier for JVM process (OS process ID is unavailable in Java) | |
THREAD_ID | VARCHAR2 | (120) | Thread ID |
Cut, paste (and edit) the following text to query this object:
SELECT METRIC_SEQUENCE
, MODULE
, METRIC_CODE
, TYPE
, STRING_VALUE
, NUMBER_VALUE
, DATE_VALUE
, AUDSID
, DB_INSTANCE
, TIME
, EVENT_KEY
, TRANSACTION_CONTEXT_ID
, SESSION_MODULE
, SESSION_ACTION
, NODE
, NODE_IP_ADDRESS
, PROCESS_ID
, JVM_ID
, THREAD_ID
FROM APPLSYS.FND_LOG_METRICS;
APPLSYS.FND_LOG_METRICS does not reference any database object
APPLSYS.FND_LOG_METRICS is referenced by following:
|
|
|