Ora-4031 Errors using Full Outer Joins
Last updated on DECEMBER 09, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Trace file or alert log shows ORA-04031 errors.
You are running sql with full outer joins.
If subpools are configured you may see an imbalance in the pools
select KSMCHIDX "SubPool", sum(ksmchsiz) Bytes from x$ksmsp
group by ksmchidx;
1 2516569200 <== may see on subpool growing large
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms