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]

VIEW: APPLSYS.FND_ADG_CONTROL#

Object Details

Object Name:	FND_ADG_CONTROL#
Object Type:	VIEW
Owner:	APPLSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CONTROL_KEY	NUMBER		Yes
ENABLE_ADG_SUPPORT	VARCHAR2	(8)	Yes
RPC_SYSTEM_STATE	NUMBER		Yes
ENABLE_COMMIT_WAIT	VARCHAR2	(8)	Yes
MAX_COMMIT_WAIT_TIME	NUMBER
RUNTIME_VALIDATE_TIMESTAMP	VARCHAR2	(8)	Yes
ALWAYS_COLLECT_PRIMARY_DATA	VARCHAR2	(8)	Yes
STANDBY_ERROR_THRESHOLD	NUMBER		Yes
SIMULATION_ERROR_THRESHOLD	NUMBER		Yes
ENABLE_STANDBY_ERROR_CHECKS	VARCHAR2	(8)	Yes
ENABLE_AUTOMATIC_REDIRECTION	VARCHAR2	(8)	Yes
ENABLE_REDIRECT_IF_VALID	VARCHAR2	(8)	Yes
STNDBY_TO_PRIMARY_LINK_OWNER	VARCHAR2	(30)
STNDBY_TO_PRIMARY_LINK_NAME	VARCHAR2	(128)
STNDBY_TO_PRIMARY_LINK_VALID	VARCHAR2	(8)	Yes
STNDBY_TO_PRIMARY_CONNSTR	VARCHAR2	(255)
ENABLE_SIMULATED_STANDBY	VARCHAR2	(8)	Yes
ENABLE_AUTO_SIMULATED_STANDBY	VARCHAR2	(8)	Yes
SIMULATED_STANDBY_SERVICE	VARCHAR2	(64)
SIMULATED_STNDBY_LINK_OWNER	VARCHAR2	(30)
SIMULATED_STNDBY_LINK_NAME	VARCHAR2	(128)
SIMULATED_STNDBY_LINK_VALID	VARCHAR2	(8)	Yes
SIMULATED_STNDBY_CONNSTR	VARCHAR2	(255)
SIMULATED_STNDBY_TRC_DIR_OBJ	VARCHAR2	(30)
PRIMARY_TO_STNDBY1_LINK_OWNER	VARCHAR2	(30)
PRIMARY_TO_STNDBY1_LINK_NAME	VARCHAR2	(128)
PRIMARY_TO_STNDBY1_LINK_VALID	VARCHAR2	(8)	Yes
PRIMARY_TO_STNDBY1_CONNSTR	VARCHAR2	(255)
MGR_STNDBY1_REQ_CLASS_APP_ID	NUMBER
MGR_STNDBY1_REQ_CLASS_ID	NUMBER
PRIMARY_TO_STNDBY2_LINK_OWNER	VARCHAR2	(30)
PRIMARY_TO_STNDBY2_LINK_NAME	VARCHAR2	(128)
PRIMARY_TO_STNDBY2_LINK_VALID	VARCHAR2	(8)	Yes
PRIMARY_TO_STNDBY2_CONNSTR	VARCHAR2	(255)
MGR_STNDBY2_REQ_CLASS_APP_ID	NUMBER
MGR_STNDBY2_REQ_CLASS_ID	NUMBER
PRIMARY_TO_STNDBY3_LINK_OWNER	VARCHAR2	(30)
PRIMARY_TO_STNDBY3_LINK_NAME	VARCHAR2	(128)
PRIMARY_TO_STNDBY3_LINK_VALID	VARCHAR2	(8)	Yes
PRIMARY_TO_STNDBY3_CONNSTR	VARCHAR2	(255)
MGR_STNDBY3_REQ_CLASS_APP_ID	NUMBER
MGR_STNDBY3_REQ_CLASS_ID	NUMBER
PRIMARY_TO_STNDBY4_LINK_OWNER	VARCHAR2	(30)
PRIMARY_TO_STNDBY4_LINK_NAME	VARCHAR2	(128)
PRIMARY_TO_STNDBY4_LINK_VALID	VARCHAR2	(8)	Yes
PRIMARY_TO_STNDBY4_CONNSTR	VARCHAR2	(255)
MGR_STNDBY4_REQ_CLASS_APP_ID	NUMBER
MGR_STNDBY4_REQ_CLASS_ID	NUMBER
PRIMARY_TO_STNDBY5_LINK_OWNER	VARCHAR2	(30)
PRIMARY_TO_STNDBY5_LINK_NAME	VARCHAR2	(128)
PRIMARY_TO_STNDBY5_LINK_VALID	VARCHAR2	(8)	Yes
PRIMARY_TO_STNDBY5_CONNSTR	VARCHAR2	(255)
MGR_STNDBY5_REQ_CLASS_APP_ID	NUMBER
MGR_STNDBY5_REQ_CLASS_ID	NUMBER
DEBUG_SLAVE_RPC	NUMBER
DEBUG_RPC	NUMBER

Query Text

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


SELECT CONTROL_KEY
,      ENABLE_ADG_SUPPORT
,      RPC_SYSTEM_STATE
,      ENABLE_COMMIT_WAIT
,      MAX_COMMIT_WAIT_TIME
,      RUNTIME_VALIDATE_TIMESTAMP
,      ALWAYS_COLLECT_PRIMARY_DATA
,      STANDBY_ERROR_THRESHOLD
,      SIMULATION_ERROR_THRESHOLD
,      ENABLE_STANDBY_ERROR_CHECKS
,      ENABLE_AUTOMATIC_REDIRECTION
,      ENABLE_REDIRECT_IF_VALID
,      STNDBY_TO_PRIMARY_LINK_OWNER
,      STNDBY_TO_PRIMARY_LINK_NAME
,      STNDBY_TO_PRIMARY_LINK_VALID
,      STNDBY_TO_PRIMARY_CONNSTR
,      ENABLE_SIMULATED_STANDBY
,      ENABLE_AUTO_SIMULATED_STANDBY
,      SIMULATED_STANDBY_SERVICE
,      SIMULATED_STNDBY_LINK_OWNER
,      SIMULATED_STNDBY_LINK_NAME
,      SIMULATED_STNDBY_LINK_VALID
,      SIMULATED_STNDBY_CONNSTR
,      SIMULATED_STNDBY_TRC_DIR_OBJ
,      PRIMARY_TO_STNDBY1_LINK_OWNER
,      PRIMARY_TO_STNDBY1_LINK_NAME
,      PRIMARY_TO_STNDBY1_LINK_VALID
,      PRIMARY_TO_STNDBY1_CONNSTR
,      MGR_STNDBY1_REQ_CLASS_APP_ID
,      MGR_STNDBY1_REQ_CLASS_ID
,      PRIMARY_TO_STNDBY2_LINK_OWNER
,      PRIMARY_TO_STNDBY2_LINK_NAME
,      PRIMARY_TO_STNDBY2_LINK_VALID
,      PRIMARY_TO_STNDBY2_CONNSTR
,      MGR_STNDBY2_REQ_CLASS_APP_ID
,      MGR_STNDBY2_REQ_CLASS_ID
,      PRIMARY_TO_STNDBY3_LINK_OWNER
,      PRIMARY_TO_STNDBY3_LINK_NAME
,      PRIMARY_TO_STNDBY3_LINK_VALID
,      PRIMARY_TO_STNDBY3_CONNSTR
,      MGR_STNDBY3_REQ_CLASS_APP_ID
,      MGR_STNDBY3_REQ_CLASS_ID
,      PRIMARY_TO_STNDBY4_LINK_OWNER
,      PRIMARY_TO_STNDBY4_LINK_NAME
,      PRIMARY_TO_STNDBY4_LINK_VALID
,      PRIMARY_TO_STNDBY4_CONNSTR
,      MGR_STNDBY4_REQ_CLASS_APP_ID
,      MGR_STNDBY4_REQ_CLASS_ID
,      PRIMARY_TO_STNDBY5_LINK_OWNER
,      PRIMARY_TO_STNDBY5_LINK_NAME
,      PRIMARY_TO_STNDBY5_LINK_VALID
,      PRIMARY_TO_STNDBY5_CONNSTR
,      MGR_STNDBY5_REQ_CLASS_APP_ID
,      MGR_STNDBY5_REQ_CLASS_ID
,      DEBUG_SLAVE_RPC
,      DEBUG_RPC
FROM APPLSYS.FND_ADG_CONTROL#;

Dependencies

[top of page]

APPLSYS.FND_ADG_CONTROL# references the following:

APPLSYS: FND_ADG_CONTROL

APPLSYS.FND_ADG_CONTROL# is referenced by following:

APPS: FND_ADG_CONTROL