Query para db_cache_size

[vieriParticipante]

show parameters db_cache_advice

*verifique se o advice tá ligado.

col size_est format 999,999,999,999 heading ‘Cache Size (m)’
col buf_est format 999,999,999 heading ‘Buffers’
col estd_rf format 999.90 heading ‘Estd Phys|Read Factor’
column estd_pr format 999,999,999 heading ‘Estd Phys| Reads’
SET LINES 80 PAGES 55
@title80 ‘DB Cache Advisor Report’
SELECT
size_for_estimate size_est,
buffers_for_estimate buf_est,
estd_physical_read_factor est_rf,
estd_physical_reads est_pr
FROM V$DB_CACHE_ADVICE
WHERE name = ‘DEFAULT’
AND block_size = (SELECT value FROM V$PARAMETER
WHERE name = ‘db_block_size’)
AND advice_status = ‘ON’;

posta o resultado da query ai pra galera debater, esse assunto parece simples mas envolve algumas variáveis.