oracledba.help
TroubleShooting

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;