Querying current session id

I want to run a query that shows the comlete currently executing SQL statement for everyone logged into the database, except for the session that's running this query. I need to know my own session ID and/or serial # for this. How can I find that out?

I can't do it by username because the user running the query might also be running other querys that I do want to see.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!