SQL*PLUS - Get SID for SAP user

[Former Member]

Is there a way to get SID,SERIAL# for a given SAP Application user using SQL*PLUS?

All I see is active users which all "share" the same database USER, can one tell which SID matches active SAP

applicaton username at any given time without using GUI?

thanks

[volker_borowski2 · Accepted solution]

No,

I think there is no relation to track down the SAP User of a runnning transaction inside Oracle only.

You need to pin the process ID of the session you like to kill (in i.e. sm50/sm66)

or the corresponding oracle shadow process pid from st04 session mointor.

I prefer ST04(old) because you get both client ID and oracle process ID there.

If you have multiple App Serveres, client PID might not be unique (therefore I prefer ST04) !

With that info (...WHERE...) you can query V$SESSION to get SID and serial to kill the session..

Be carefull with that

Volker