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

TABLE: APPLSYS.FND_SIDS

Object Details
Object Name: FND_SIDS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_SIDS
Subobject Name:
Status: VALID


This table registers the SIDs in use on the system. SIDs are used by tnsnames.ora and
listener.ora to connect to network services like a database instance, FNDFS, or FNDSM.
Each database instance in has a unique SID. By storing the SIDs in this table we allow
them to be easily changed when a database instance is cloned, and avoid having to track
down and update individual references. Fnd_database_instances will point to this table
(i.e. a database instance has a SID). Fnd_tns_aliases also points to this table (i.e. an
alias may use a SID to tell the listener what to connect to). Dummy SIDs will be seeded
for "FNDFS" and "FNDSM", which are static names.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_SIDS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSID_GUID
Columns
Name Datatype Length Mandatory Comments
SID_GUID RAW (16) Yes Primary Key
SID VARCHAR2 (16) Yes SID
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
Query Text

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


SELECT SID_GUID
,      SID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_SIDS;

Dependencies

[top of page]

APPLSYS.FND_SIDS does not reference any database object

APPLSYS.FND_SIDS is referenced by following:

SchemaAPPLSYS
ViewFND_SIDS#