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_DATABASE_INSTANCES

Object Details

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

The Fnd_Database_Instances table stores instance specific information.
Every database has one or more instance.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_DATABASE_INSTANCES_U1	NORMAL	UNIQUE	APPS_TS_SEED	DB_GUID INSTANCE_NUMBER
FND_DATABASE_INSTANCES_U2	NORMAL	UNIQUE	APPS_TS_SEED	DB_GUID INSTANCE_NAME
FND_DATABASE_INSTANCES_U3	NORMAL	NONUNIQUE	APPS_TS_SEED	DB_GUID INSTANCE_GUID

Columns

Name	Datatype	Length	Mandatory	Comments
DB_GUID	RAW	(16)	Yes	Foreign key to FND_DATABASES
INSTANCE_NAME	VARCHAR2	(16)	Yes	Instance name set in initSID.ora file.
INSTANCE_NUMBER	NUMBER		Yes	Instance number from v$instance.
SID	VARCHAR2	(16)		SID name for this instance. Used in tnsnames.ora file.
DEFAULT_TNS_ALIAS_GUID	RAW	(16)	Yes	Default TNS alias used to contact this instance. Key into fnd_tns_aliases. (Note: Using a GUID will make it easier to alter the alias name upon cloning.) This alias should be mapped only to this instance, and not to a service that balances load across multiple instances. Note that there could be multiple TNS aliases that point to this instance
LOCAL_LISTENER_ALIAS	RAW	(16)		ID for the local TNS Listener Alias. Key into fnd_tns_aliases. Used to set the LOCAL_LISTENER initialization parameter
REMOTE_LISTENER_ALIAS	RAW	(16)		ID for the Remote TNS Listener Alias. Key into fnd_tns_aliases. Used to set the REMOTE_LISTENER initialization parameter.
CONFIGURATION	VARCHAR2	(30)		Named configuration for AD init.ora checking
DESCRIPTION	VARCHAR2	(2000)		Description set by user
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column
SERVER_GUID	RAW	(16)	Yes	server guid
INTERCONNECT_NAME	VARCHAR2	(255)		Private interconnect name, used for cluster manager
INSTANCE_GUID	RAW	(16)	Yes	instance id
SID_GUID	RAW	(16)	Yes	SID id

Query Text

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


SELECT DB_GUID
,      INSTANCE_NAME
,      INSTANCE_NUMBER
,      SID
,      DEFAULT_TNS_ALIAS_GUID
,      LOCAL_LISTENER_ALIAS
,      REMOTE_LISTENER_ALIAS
,      CONFIGURATION
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SERVER_GUID
,      INTERCONNECT_NAME
,      INSTANCE_GUID
,      SID_GUID
FROM APPLSYS.FND_DATABASE_INSTANCES;

Dependencies

[top of page]

APPLSYS.FND_DATABASE_INSTANCES does not reference any database object

APPLSYS.FND_DATABASE_INSTANCES is referenced by following:

APPS: FND_DATABASE_INSTANCES