On database 12cr1 we have seen ORA-07445 [kkpamIsPKeyFKeyJoin()+154] error when reference partitioning and join are used between tables. Actually error has not occured for all sql statemens except one.
For Oracle support setting parameter "_full_pwise_join_enabled" to false can be used to avoid this error.I have used hint for specific sql like select /*+ OPT_PARAM('_full_pwise_join_enabled' 'false') */ .
By breaking large joins into small joins , memory is used better and this process is distributed amaong parallel server processes effective. So Benefits of partition-wise join must be thought before turn off this parameter at database level.
No comments:
Post a Comment