Cómo revisar errores de jobs de 10g

Para revisar qué pasó con jobs detenidos o fallidos en Oracle 10g:

SQL> column LOG_DATE format a40
SQL> column JOB_NAME format a20
SQL> column ADDITIONAL_INFO format a40
SQL> select LOG_ID, LOG_DATE, JOB_NAME, STATUS, ADDITIONAL_INFO from DBA_SCHEDULER_JOB_RUN_DETAILS
where STATUS in ('STOPPED','FAILED') order by LOG_DATE;


LOG_ID  LOG_DATE                             JOB_NAME      STATUS   ADDITIONAL_INFO
------- ------------------------------------ ------------- -------- ----------------------------------------
   6076 22-MAR-11 09.22.00.880338 PM -06:00  MY_JOB        FAILED   ORA-30036: unable to extend segment by O
                                                                    RA-30036: unable to extend segment by 8
                                                                    in undo tablespace 'UNDO'
                                                                    ORA-06512: at "SYS.MY_PROCEDURE",
                                                                    line 16
                                                                    ORA-06512: at line 1
                                                                    in undo tablespace ''

   6085 23-MAR-11 09.22.00.608055 PM -06:00  MY_JOB        FAILED   ORA-30036: unable to extend segment by O
                                                                    RA-30036: unable to extend segment by 8
                                                                    in undo tablespace 'UNDO'
                                                                    ORA-06512: at "SYS.MY_PROCEDURE",
                                                                    line 16
                                                                    ORA-06512: at line 1
                                                                    in undo tablespace ''

   6088 24-MAR-11 05.45.00.821410 AM -06:00  MY_OTHER_JOB  STOPPED  REASON="Stop job called"