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>