Correct number with dynamic sampling level 8 but wrong with 9
Hi All,
My DB is 11.1.
The SQL looks like:
The plan looks like
My DB is 11.1.
The SQL looks like:
SELECT <font color="#006400">/*+ parallel(SHPMT,4) dynamic_sampling(SHPMT 8)*/</font> * FROM OMTH_SFCT SHPMT, O_1_SFCT PRMTN_PROD, O_DIM PROD WHERE PRMTN_PROD.BID = PROD.BID AND PRMTN_PROD.BID = SHPMT.BID AND PRMTN_PROD.PID = SHPMT.PID AND PRMTN_PROD.PID = PROD.PID AND PRMTN_PROD.PRID = SHPMT.PRID AND SHPMT.DATE_ID >= SYS_CONTEXT(<font color="#000080">'APP_CTX'</font>,<font color="#000080">'MIN_DATE_SKID'</font>) -- sys_context returns 10000
The plan looks like
-------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | -------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT |
0