eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LOG_METRICS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LOG_METRICS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CONTEXT_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_LOG_METRICS does not reference any database object

APPLSYS.FND_LOG_METRICS is referenced by following:

APPS: FND_LOG_METRICS