Oracle Apps DBA Interview Questions

GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

 
Q. Where GWYUID defined & what is its used in Oracle Applications ?

GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by think clients.

 
Q. What is difference between GUEST_USER_PWD (GUEST/ORACLE) & GWYUID ?

GUEST_USER_PWD(Guest/Oracle) is used by JDBC Thin Client where as GWYUID is used by Thick Clients like via Forms Connections.

Q. How to check number of forms users at any time ?

Forms Connections initiate f60webmx connections so you can use
ps -ef | grep f60webmx | wc -l

0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.
* Corrected by anonymous User (You will see lot of other info from him soon)

  Good luck for your interview. If you are not happy with quality of questions or want to submit Oracle 11i Apps Interview questions Mail Me.