My Oracle Support Banner

Automatic Big Table Caching (Doc ID 2866539.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal


1) How much BT-cache in bytes is available to me? 

 

select * from V$BT_SCAN_CACHE;

BT_CACHE_ALLOC BT_CACHE_TARGET OBJECT_COUNT MEMORY_BUF_ALLOC MIN_CACHED_TEMP CON_ID
-------------- --------------- ------------ ---------------- --------------- ----------
.797859624 80 132 889949 1000 0

 

2) I want to add a table 20Gb fully in memory, how much should I increase the DB_CACHE_SIZE, 20G?


3) Isn't the DB_CACHE_SIZE parameter automatically controlled by oracle when ASMM is used? we are using ASMM.


 

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
References


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