My Oracle Support Banner

ORA-4031 in LARGE POOL with SHARED SERVER Configuration on 9i (Doc ID 223153.1)

Last updated on SEPTEMBER 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 9.2.0.8 [Release 9.0.1 to 9.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic UNIX

Symptoms

You are running database with Shared Server (MTS) configuration.

Error occurs pointing to large pool
ORA-04031: unable to allocate 88 bytes of shared memory ("large pool","unknown object","session heap","frame")

New, shared server sessions may fail when connecting to the database.

Cause

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.