How to get session number?

From: Dwayne K. Lanclos <lanclosd_at_bcstec.ca.boeing.com>
Date: Thu, 4 Aug 1994 18:25:17 GMT
Message-ID: <Cu0wI6.7Gt_at_bcstec.ca.boeing.com>

If I'm in PL/SQL, how do I obtain the current session ID? I'm not the DBA. I know there's a couple of tables out there (V$PROCESS, V$SESSION) that contain this information for the current session, however I don't know how to query them properly because the same user can have multiple concurrent sessions.

I've got a batch job that needs immediate access to update a block of records in a table. My DBA needs my session ID so that he can determine the resources that I am waiting on and terminate any other sessions that are holding the resources I need.

Thanks in advance.

-- 
Dwayne K. Lanclos		lanclosd_at_lacmhs.boeing.com

"War doesn't determine who's right, just who's left."

Received on Thu Aug 04 1994 - 20:25:17 CEST

This message: [ Message body ]
Next message: George McDuffie: ""ad hoc" query tools"
Previous message: Kevin Mara: "*** SQL Plus Problem - Help! ***"
Next in thread: Michael P. Vergara: "Re: How to get session number?"
Reply: Bob Rosales: "Re: How to get session number?"
Reply: David Pinkus: "Re: How to get session number?"
Reply: Doug Harris: "Re: How to get session number?"
Reply: Michael P. Vergara: "Re: How to get session number?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message