SQL-ID from Currently Executing SQL
SET LINESIZE 220
SET PAGESIZE 999999
COL sid FORMAT 99999
COL username FORMAT A20
COL schemaname FORMAT A20
COL status FORMAT A8
COL sql_id FORMAT A13
COL event FORMAT A30
SELECT
sid,
username,
schemaname,
status,
sql_id,
event
FROM
v$session
WHERE
type = 'USER'
AND status = 'ACTIVE'
AND sql_id IS NOT NULL
ORDER BY
sid;