Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
OS:Linux
I have a list of DBA jobs & DBMS scheduler jobs. I want to view code so that I can understand what data actually is getting moved or deleted. I want to investigate these jobs... Please advise how can I succeed.
DBMS Scheduler Jobs:
OWNER JOB_NAME JOB_TYPE NEXT_RUN_DATE STATE COMMENTS
---------- ------------------------------ ---------------- ------------------------- --------------- ----------------------------------------
SYS SM$CLEAN_AUTO_SPLIT_MERGE PLSQL_BLOCK 25-MAY-16 12.00.00.000000 SCHEDULED auto clean job for auto split merge
AM UTC
SYS RSE$CLEAN_RECOVERABLE_SCRIPT PLSQL_BLOCK 25-MAY-16 12.00.00.600000 SCHEDULED auto clean job for recoverable script
AM UTC
SYS BSLN_MAINTAIN_STATS_JOB 29-MAY-16 12.00.00.000000 SCHEDULED Oracle defined automatic moving window b
AM +00:00 aseline statistics computation job
SYS DRA_REEVALUATE_OPEN_FAILURES STORED_PROCEDURE SCHEDULED Reevaluate open failures for DRA
SYS ORA$AUTOTASK_CLEAN 25-MAY-16 03.00.00.600000 SCHEDULED Delete obsolete AUTOTASK repository data
JOB NEXT_DATE INTERVAL LAST_DATE WHAT
---------- ---------------- -------------------- -------------------- ------------------------------------------------------------
4001 24/05/2016 23:56 sysdate + 8/24 24/05/2016 15:56 wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs =>
24);
4002 24/05/2016 17:08 sysdate + 10/1440 24/05/2016 16:58 wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('S
MTP_HOST_ADDRESS'),wwv_flow_platform.get_preference('SMTP_HO
ST_PORT'));