Query v$sqlarea for running dba jobs : sqlarea « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. sqlarea

SQL>
SQL>
SQL> SELECT sql_text, address, hash_value,
  2         sharable_mem, kept_versions
  3  FROM   v$sqlarea
  4  WHERE  INSTR(UPPER(sql_text), 'DBA_JOBS_RUNNING') > 0
  5  and    rownum < 50;

SQL_TEXT
--------------------------------------------------------------------------------
ADDRESS  HASH_VALUE SHARABLE_MEM KEPT_VERSIONS
-------- ---------- ------------ -------------
SELECT sql_text, address, hash_value,        sharable_mem, kept_versions FROM
v$sqlarea WHERE  INSTR(UPPER(sql_text), 'DBA_JOBS_RUNNING') > 0 and    rownum <
50
1D18CBD0 2636155149        16967             0

SELECT a.job, what,        TO_CHAR(SYSDATE, 'mm/dd/yyyy hh24:mi:ss') now,
 TO_CHAR(a.this_date, 'mm/dd/yyyy hh24:mi:ss') this FROM   dba_jobs_running a, d
ba_jobs b WHERE  a.job = b.job and rownum < 50
1D1B8F38 1543191033        80595             0

SQL_TEXT
--------------------------------------------------------------------------------
ADDRESS  HASH_VALUE SHARABLE_MEM KEPT_VERSIONS
-------- ---------- ------------ -------------


SQL>