Hi all,
I'm having a problem and hope that someone can lead me in the right direction for troubleshooting.
Everything has been running ok for months and then 2 days ago I had an extract table fail with ORA-12801 and 2 more tables today.
This is an AIX Power 7 64bit with Oracle 12c (12.1.0.2) with 128 GB of physical RAM
Error Message:
ORA-12801: error signaled in parallel query server P076
ORA-12853: insufficient memory for PX buffers: current 392976K, max needed 8547984K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
ORA-12853: insufficient memory for PX buffers: current 392880K, max needed 8547984K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
Server Memory Setting:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 63G
sga_target big integer 63G
unified_audit_sga_queue_size integer 1048576
SQL> show parameter large_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 384M
SQL> show parameter large_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 384M
SQL> show parameter cpu_count
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 32
SQL> show parameter parallel_threads_per_cpu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_threads_per_cpu integer 4
SQL> show parameter PARALLEL_SERVERS_TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_servers_target integer 1024
Any and all ideas are appreciated,
Thanks,
Mike