How to see resumable timeout of another session in oracle?
DBA_RESUMABLE


  ...
  
  TIMEOUT | NUMBER | Timeout of the resumable statement
  
  ...


Session 1:

SQL&gt; select sys_context('userenv', 'sid') from dual;

SYS_CONTEXT('USERENV','SID')
--------------------------------------------------------------------------------
53

SQL&gt; alter session enable resumable timeout 600 name 'hello world';

Session altered.


Session 2:

SQL&gt; select session_id, timeout, name from dba_resumable;

SESSION_ID    TIMEOUT NAME
---------- ---------- ------------------------------
        53        600 hello world