SQL Performance (MOSC)

MOSC Banner

Will a SQL MERGE statement using a parallel(16) hint use more Shared memory than using parallel (8)

edited Feb 26, 2020 10:33AM in SQL Performance (MOSC) 4 commentsAnswered ✓

Environment:  Oracle EE 12.1.0.2 on Exadata

I'm getting some of the following errors when doing a MERGE using a parallel(16) hint:

ERROR at line 1: ORA-12853: insufficient memory for PX buffers: current 174848K, max needed 1244160K ORA-04031: unable to allocate 32792 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","PX msg pool")

It was suggested to me to lower the degree to 8.

Will that affect the Shared Pool size and potentially eliminate this error?

The tables in question are not partitioned and the DOP is one (1) on both tables.

Thanks very much!!

-gary

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