› Fóruns › Banco de dados Oracle › Monitorando o Dictionary Cache – Banco 9i Windows › Monitorando o Dictionary Cache – Banco 9i Windows
17 de abril de 2010 às 12:10 am
#93691
vieriParticipante
SELECT RPAD(‘Sort’,30) Item,
TRUNC((sort_disk / sort_memory * 100),5) “Sort contention”,
CASE WHEN TRUNC((sort_disk / sort_memory * 100),5) < 1
THEN 'Ok (menor que 1%)'
ELSE 'Incrementar: SORT_AREA_SIZE'
END "Ação …"
FROM (SELECT VALUE sort_memory
FROM v$sysstat
WHERE NAME IN ('sorts (memory)')) ,
(SELECT VALUE sort_disk
FROM v$sysstat
WHERE NAME IN ('sorts (disk)'))