이럴 때는 쿼리에서 쓰인 Stored Function 을 의심해보자.
Function 중에 parallel_enable 이 되어 있지 않은 놈이 있다면 parallel_enable 을 붙여준다!
자세한 것은 포이어슈타인의 오라클 PL/SQL 프로그래밍을 참조!!!
Plan Table
----------------------------------------------------------------------------
| Operation | Name |
----------------------------------------------------------------------------
| PX COORDINATOR FORCED SERIAL | |
| PX SEND QC (RANDOM) |:TQ10010 |
| FILTER | |
| HASH GROUP BY | |
| PX RECEIVE | |
| PX SEND HASH |:TQ10009 |
| HASH GROUP BY | |
| HASH JOIN RIGHT OUTER | |
| BUFFER SORT | |
| PX RECEIVE | |
| PX SEND BROADCAST |:TQ10000 |
| VIEW | |
| SORT GROUP BY | |
| TABLE ACCESS BY GLOBAL INDEX|TR_ORD_PRD |
| INDEX RANGE SCAN |IX5_TR_ORD_PRD |
| VIEW | |
| HASH GROUP BY | |
| PX RECEIVE | |
| PX SEND HASH |:TQ10008 |
| HASH GROUP BY | |
| HASH JOIN RIGHT OUTER | |
| PX RECEIVE | |
| PX SEND HASH |:TQ10006 |
| PX BLOCK ITERATOR | |
| TABLE ACCESS FULL |MB_PRVT_MEM |
| PX RECEIVE | |
| PX SEND HASH |:TQ10007 |
| HASH JOIN RIGHT OUTER BUF| |
| PX RECEIVE | |
| PX SEND HASH |:TQ10004 |
| PX BLOCK ITERATOR | |
| TABLE ACCESS FULL |MB_MEM_MG_GR |
| PX RECEIVE | |
| PX SEND HASH |:TQ10005 |
| HASH JOIN RIGHT OUTER | |
| PX RECEIVE | |
| PX SEND HASH |:TQ10002 |
| VIEW | |
| HASH UNIQUE | |
| WINDOW SORT | |
| PX RECEIVE | |
| PX SEND HASH |:TQ10001 |
| PX BLOCK ITERA| |
| TABLE ACCESS |MB_MEM_HIST |
| PX RECEIVE | |
| PX SEND HASH |:TQ10003 |
| PX BLOCK ITERATOR | |
| TABLE ACCESS FULL |MB_MEM |
----------------------------------------------------------------------------
Posted by maceo
