How to see resumable timeout of another session in oracle? How I see the setting of timeout about resumable of another session? I've found the function dbms_resumable.get_timeout, but there is no way of inform some parameters about a specified session.
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