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 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]
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.