Technology Stack - EBS (MOSC)

MOSC Banner

how to find SID from f60webmx OS process ID in multinode environment?

edited Aug 20, 2021 11:22AM in Technology Stack - EBS (MOSC) 5 commentsAnswered
 Hi,
I am following the Metalink Note ID 185762.1 to find out the the apps User Using The O/S PID For Forms Users In 11i.

However I am not able to get any database session ID for any f60webmx process from the query mentioned in the note in my multi-node installation:
select
d.user_name "User Name", b.sid SID,b.serial# "Serial#", c.spid "srvPID", a.SPID "ClPID", to_char(START_TIME,'DD-MON-YY HH:MM:SS') "STime" from fnd_logins a, v$session b, v$process c, fnd_user d where b.paddr = c.addr and a.pid=c.pid and a.spid = b.process and d.user_id = a.user_id and (d.user_name = 'USER_NAME' OR 1=1) and a.SPID = &PID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center