How to retrieve SID fromTOracleSession

[Vinu]

Hi All,
Is there any way to get the sessionid from TOraclesession class? I need this to query the V$SESSION view to fetch some details of a particular session.
Thanks,
Pradeep

 

[Marco Kalter]

You can use TOracleSession.AUDSID for this. You can use its value to query the v$session view. For example:

select * from v$session where audsid = :v_audsid

This will return 1 row for your session.