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_OAM_METVAL

Object Details

Object Name:	FND_OAM_METVAL
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_OAM_METVAL
Subobject Name:
Status:	VALID

This table will store Applications user's metalink credentials

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_OAM_METVAL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	METRIC_SHORT_NAME NODE_NAME ZD_EDITION_NAME
FND_OAM_METVAL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	METRIC_SHORT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
METRIC_SHORT_NAME	VARCHAR2	(30)	Yes	Internal name for metric
METRIC_VALUE	VARCHAR2	(256)		Value of the metric
STATUS_CODE	NUMBER			If applicable, status of the metric.
GROUP_ID	NUMBER		Yes	Foreign key to fnd_oam_met_grps_vl
SEQUENCE	NUMBER		Yes	The order in which the metric will be displayed within its group
NODE_NAME	VARCHAR2	(30)		Host name associated with the metric if applicable
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)	Yes	Standard Who Column
METRIC_TYPE	VARCHAR2	(1)		I - Integer or S - Status (i.e. Up or Down)
THRESHOLD_OPERATOR	VARCHAR2	(1)		Value for operator for comparison with threshold value
THRESHOLD_VALUE	VARCHAR2	(256)		Value specified by the user for threshold
ALERT_ENABLED_FLAG	VARCHAR2	(1)	Yes	Whether or not alerting is enabled for this metric
COLLECTION_ENABLED_FLAG	VARCHAR2	(1)	Yes	Whether or not metric values should be computed for this metric
LAST_COLLECTED_DATE	DATE			The date on which the metric value was last collected
IS_SUPPORTED	VARCHAR2	(1)	Yes	Indicates whether this metric is supported by OAM or not
IS_CUSTOMIZED	VARCHAR2	(1)	Yes	Indicates whether this metric has been modified by the user. This is a flag for the seed data loader so that we do not overwrite user updated values. Default values is N
INTERVAL_COUNTER	NUMBER			Keeps count of the number of times the collection program has run
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT METRIC_SHORT_NAME
,      METRIC_VALUE
,      STATUS_CODE
,      GROUP_ID
,      SEQUENCE
,      NODE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      METRIC_TYPE
,      THRESHOLD_OPERATOR
,      THRESHOLD_VALUE
,      ALERT_ENABLED_FLAG
,      COLLECTION_ENABLED_FLAG
,      LAST_COLLECTED_DATE
,      IS_SUPPORTED
,      IS_CUSTOMIZED
,      INTERVAL_COUNTER
,      ZD_EDITION_NAME
FROM APPLSYS.FND_OAM_METVAL;

Dependencies

[top of page]

APPLSYS.FND_OAM_METVAL does not reference any database object

APPLSYS.FND_OAM_METVAL is referenced by following:

APPLSYS: FND_OAM_METVAL#