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 laterInformation 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 |