My Oracle Support Banner

SCRIPT: Check the Large Pool sizing when Parallel Processing is in use and ORA-4031 errors occur. (Doc ID 1504173.1)

Last updated on JANUARY 30, 2025

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 19.0.0.0 [Release 10.2 to 19]
Information in this document applies to any platform.



Goal

These scripts query the database settings and perform calculations to determine if the Large Pool size is suited to the settings for Parallel processing.

ORA-4031 errors for the Large Pool may be reported if the DEFAULT parallel_max_servers is in effect, but the minimum Large Pool is too small.

For example, the DEFAULT parallel_max_servers may be 400 due to the CPU_COUNT and PARALLEL_THREADS_PER_CPU settings, but the minimum Large Pool only has enough for 8 memory chunks (granules) and theortically 8-16 Parallel Servers. 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.