查看 DBMS 作业日志 oracle
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21982955/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
View the DBMS jobs log oracle
提问by Vinod Chelladurai
I have a scheduled a job in DBMS jobs (not DBMS scheduler). I can see the job has failed in weekends. I want to see the log file with failure reason. Where i can i find this?
我在 DBMS 作业（不是 DBMS 调度程序）中安排了一个作业。我可以看到工作在周末失败了。我想查看失败原因的日志文件。我在哪里可以找到这个？
Any suggestions please?
请问有什么建议吗？
Thanks in advance.
提前致谢。
回答by Corrado Piola
For DBMS_SCHEDULER (as noted by Frank Schmitt) try this:
对于 DBMS_SCHEDULER（如 Frank Schmitt 所述），请尝试以下操作：
SELECT *
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
ORDER BY LOG_DATE DESC;
and then look in your bdump folder, for the trace files.
然后在您的 bdump 文件夹中查找跟踪文件。
For DBMS_JOB you can view your alert log file:
对于 DBMS_JOB，您可以查看警报日志文件：
SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'background_dump_dest';
or
或者
SELECT VALUE
FROM V$SPPARAMETER
WHERE NAME = 'background_dump_dest';
The alert log file has a name like "alert_orcl.log", if your database name is the default "orcl".
如果您的数据库名称是默认的“orcl”，则警报日志文件的名称类似于“alert_orcl.log”。
回答by Lksh
For DBMS_JOB you'd see the information about failed job in the database alert log. There you'd also see a name of the tracefile with more information about the failure.
对于 DBMS_JOB，您会在数据库警报日志中看到有关失败作业的信息。在那里，您还会看到跟踪文件的名称，其中包含有关失败的更多信息。
