- 博客(4)
- 收藏
- 关注
原创 One case in which CBO will make wrong estimation based on accurate and fresh statistics
Sometimes we design tables like thisOPT_CAL_MASTR_DIM(CAL_MASTR_SKID NUMBER not null primary key, MTH_SKID number not null );In this table, CAL_MASTR_SKID is a subset of MTH_SKID, which
2011-02-24 16:04:00 813
原创 Tuning one SQL that is generated by report tool
Recently, I encoutered one long running SQL which needs 7 minutes to complete. The sql looks like: select sum(nvl(T1589240.ACTL_GIV_AMT , 0)) as c1, T1590424.ACN as c2, T1590424.NAME as c3, … … T1589324.PRMTN_SKID as c23 from OPT_ACCT_FDIM T1590424, OPT_BU
2011-01-26 12:20:00 611
原创 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
原创 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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人