My Oracle Support Banner

Multiple BUFFER subcaches: What is the total BUFFER CACHE size? (Doc ID 138226.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Purpose

  As introduced in Oracle9i, the database buffer cache can be composed of 7 sub-caches.
  This note answers the following questions:
  - Which buffer caches are initialized and available for tablespace creation with different block sizes?
  - What is the global size of the database buffer cache?

Scope

  For DBAs using the Multiple Block Size new feature in Oracle9i which enables the creation of tablespaces with different block sizes.

Details

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.