My Oracle Support Banner

How To Determine The Default Number Of Subpools Allocated During Startup (Doc ID 455179.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


This document explains the algorithm for determining the default number of subpools allocated during database startup.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 The # of CPUs
 The shared pool size
 Manual Memory Mangement
 Automatic Shared Memory Management & Automatic Memory Management
 Number of subpools
 Example 1:
 Example 2:
 Example 3:
 Example 4:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.