1) v$sqlarea
2) v$session_longops
3) v$session (joined with v$sqlarea)