上了QUEST监控数据库软件,遇到第二个database bug,即Bug 5928612,Performance Analysis无法在历史中看到dbms_job所发出的SQL语句,即发现了某时段SQL执行异常也无法获得具体的SQL语句,反而只能用AWR/ADDM来取得当时的Top语句.目前数据库版本为10.2.0.2,需要升级到10.2.0.4以上.
Description
If a job is run through DBMS_JOB then the columnsSQL_ADDRESS and SQL_HASH_VALUE are not populated in V$SESSION which can hinder performance monitoring.(the columns show as 0).
A similar issue exists for DBMS_SCHEDULER under <Bug:5140631>Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/2073/viewspace-1020275/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Aix下使用压缩命令压缩目录
下一篇：
RAC数据库COPY到单实例的测试环境
请登录后发表评论
登录
全部评论
