My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]
Oracle Database Cloud Schema 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
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

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

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!

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

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