FND_OAM_FORMS_RTI
- From: "Fadi Hasweh" <fhasweh@xxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Tue, 17 Oct 2006 10:58:50 +0200
I found the below note on etrm but I could not find any references on
how to implement OAMSG loader can any one drop a hint.
Fadi
[Dependency Information]
<https://etrm.oracle.com/pls/etrmlatest/etrm_pnav.show_object?c_name=FND
_OAM_FORMS_RTI&c_owner=APPLSYS&c_type=TABLE#dependencies#dependencies>
________________________________
TABLE: APPLSYS.FND_OAM_FORMS_RTI
Object Details
Object Name:
FND_OAM_FORMS_RTI
Object Type:
TABLE
Owner:
APPLSYS
FND Design Data:
FND.FND_OAM_FORMS_RTI
<https://etrm.oracle.com/pls/etrmlatest/etrm_fndnav.show_object?n_tabid=
85042&n_appid=0&c_type=TABLE>
Subobject Name:
Status:
VALID
It stores the Forms Listener runtime process
client infomation uploaded by the OAMGS Loader.
Storage Details
Tablespace:
APPS_TS_TX_DATA
PCT Free:
10
PCT Used:
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]
<https://etrm.oracle.com/pls/etrmlatest/etrm_pnav.show_object?c_name=FND
_OAM_FORMS_RTI&c_owner=APPLSYS&c_type=TABLE#top-of-page#top-of-page>
APPLSYS.FND_OAM_FORMS_RTI does not reference any database object
APPLSYS.FND_OAM_FORMS_RTI is not referenced by any database object
________________________________
________________________________
Copyright (c) 2001 - 2005, Oracle
Oracle Proprietary, Confidential Information - Use Restricted by
Contract
<https://etrm.oracle.com/pls/etrmlatest/uiutil.copyright_notice>
"This email is intended for the above named adressee (s) only and may contain
confidential and/or privilege information and should not be used by anyone who
is not the original intended recipient(s). Any review, print, copy, reliance or
distribution by others or forwarding without express permission is strictly
prohibited If you have received this email in error, kindly notify the sender
immediately by reply email and delete this email and any attachments from your
mailbox or any other storage mechanism. Thank you.
Email transmission cannot be guaranteed to be secured or error free, as
information could be intercepted, corrupted, lost, destroyed, received late or
incomplete, or could contain viruses. The sender therefore does not accept
liability for any error or omission in the contents of this message, which
arises as a result of email transmission. Opinions, conclusions and other
information in this message that do not relate to the official business of
Umniah Mobile Company and is not its responsibility shall be understood as
neither given nor endorsed by the organization."
Other related posts:
