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

TABLE: APPLSYS.FND_OAM_FORMS_RTI

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


It stores the Forms Listener runtime process
client infomation uploaded by the OAMGS Loader.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_FORMS_RTI_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRTI_ID
Columns
Name Datatype Length Mandatory Comments
RTI_ID NUMBER
Yes Sequence num used to identify a logfile for a specific runtime instance.
CONCURRENT_QUEUE_ID NUMBER

CQID of GSM Forms Listener Instance.
QUEUE_APPLICATION_ID NUMBER
Yes Application id.
PID NUMBER
Yes Runtime process ID.
THREADID NUMBER

Runtime process's thread IS, NT only.
IPADDRESS VARCHAR2 (32)
Client IP.
NODE VARCHAR2 (128) Yes Middle tier node name where the runtime process is running.
PORT VARCHAR2 (8) Yes Port number where the Forms Listener is running.
USERNAME VARCHAR2 (128)
Connected APPS username from rti file.
CONNECT_TIME DATE

Timestamp when runtime process started.
MEM_USAGE NUMBER

memory usage in kilobytes obtained from OS or ifctl60 (NT)
CPU_USAGE VARCHAR2 (32)
CPU usage time in hh:mm:ss obtained from OS or ifctl60 (NT)
FILENAME VARCHAR2 (128)
Full path to the rti files, needed for purging.
LAST_UPDATE_TIME DATE

Needed for purging.
Query Text

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


SELECT RTI_ID
,      CONCURRENT_QUEUE_ID
,      QUEUE_APPLICATION_ID
,      PID
,      THREADID
,      IPADDRESS
,      NODE
,      PORT
,      USERNAME
,      CONNECT_TIME
,      MEM_USAGE
,      CPU_USAGE
,      FILENAME
,      LAST_UPDATE_TIME
FROM APPLSYS.FND_OAM_FORMS_RTI;

Dependencies

[top of page]

APPLSYS.FND_OAM_FORMS_RTI does not reference any database object

APPLSYS.FND_OAM_FORMS_RTI is referenced by following:

SchemaAPPS
SynonymFND_OAM_FORMS_RTI