DBA SGA Buffer Cache Object Usage

Description

Categories
Enginatics
Repository
GitHub
SGA buffer cache space usage by object names (in MB).
'Object Percentage' shows how much of one particular object is currently stored in the buffer cache.
100% means that the object is completely in the buffer cache.

Current SGA memory usage is also listed in views:
select * from v$sga
select * from v$sgainfo
select * from v$sga_dynamic_components

Arup Nanda gives a good explanation on how the buffer cache works:
http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html

SQL 94 lines

Parameters 1

ParameterTypeList of values SQL
Show Block StatusLOV
,gb.status,
gb.status_code,
gb.dirty,
gb.temp