Troubleshooting
文章平均质量分 81
DBA_HP_CHINA
这个作者很懒,什么都没留下…
展开
-
Long running JOB due to parallel execution
Today I met a long running job. ETL developer said that this job had been running for about 6 hours, request DBA's help. I asked them to provide SID , which is 4861. According the providing sid, I checked the wait event is PX Deq: Execute Reply , which mea原创 2011-01-05 20:19:00 · 768 阅读 · 2 评论 -
Oracle11g CBO issue
<br />Main Env info : OLAP, RAC, 4 node. block size=16k<br />SQL> select * from v$version where rownum=1;<br />BANNER<br />-----------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.原创 2011-01-12 23:08:00 · 876 阅读 · 0 评论