doc
  Full table Scan 하고 있는 세션을 찾기
#

SELECT a.username, a.SID, a.osuser, a.machine, a.program, a.status, b.opname,
      b.start_time, b.last_update_time, c.sql_text
  FROM v$session a, v$session_longops b, v$sqltext c
WHERE b.opname LIKE '%Table Scan%'
  AND a.SID = b.SID
  AND a.serial# = b.serial#
  AND a.sql_address = c.address;