Query para db_cache_size

[vieriParticipante]

posta dessas duas querys também.

SELECT NAME, PHYSICAL_READS, DB_BLOCK_GETS, CONSISTENT_GETS,
1 – (PHYSICAL_READS / (DB_BLOCK_GETS + CONSISTENT_GETS)) “Hit Ratio”
FROM V$BUFFER_POOL_STATISTICS;

SELECT NAME, VALUE
FROM V$SYSSTAT
WHERE NAME IN (‘db block gets from cache’,
‘consistent gets from cache’,
‘physical reads cache’);

Caso esteja procurando as campeãs de uso de buffer:

SELECT NAME, VALUE
FROM V$SYSSTAT
WHERE NAME IN (‘db block gets from cache’,
‘consistent gets from cache’,
‘physical reads cache’);