Excess PGA memory used by hash joins [bug 5947623]

it is possible for a query to allocate too much memory executing a hash join 
over large volumes of data with few distinct join key values.
The impact on 64-bit systems is greater.

This is not really a  as the fix only makes the query to spill to
disk earlier.

Workaround:
set "_pga_max_size"

[@more@]

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=Bug%205947623%20-%20Excess%20PGA%20memory%20used%20by%20hash%20joins&viewingMode=1143&from=BOOKMARK&bmDocID=5947623.8&bmDocType=PATCH&bmDocDsrc=DOCUMENT))

我们的系统是11.1.0.7 受此bug影响,设置了_pga_max_size 1600M

但pga in use仍会涨到30多G,不知算不算多.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/94384/viewspace-1028629/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94384/viewspace-1028629/