Automatic Big Table Caching (Doc ID 2866539.1)

Last updated on JULY 20, 2024

Applies to:

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

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