Database Tuning (MOSC)

MOSC Banner

Correct number with dynamic sampling level 8 but wrong with 9

edited Aug 7, 2011 10:09PM in Database Tuning (MOSC) 8 commentsAnswered ✓
Hi All,

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                         |       

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center