What are your favorite monitoring queries for SGA memory problems?
Hi,
If you have a favorite script you use, post it here. Describe why it is helpful and any insights, tips, hints about use of the query or queries and what the data tells you about potential ORA-4031 problems.
For example, on Oracle 8 and higher, there is a view to breakdown actual memory "health" in the Shared Pool--v$sql_shared_memory.
col alloc_class heading "Allocation"
col total format 999,999,999,999 heading "Total"
col average format 999,999,999.99 heading "Average"
col maximum format 999,999,999 heading "Maximum"
select alloc_class, sum(chunk_size) total, avg(chunk_size) average, max(chunk_size) maximum
from v$sql_shared_memory group by alloc_class
If you have a favorite script you use, post it here. Describe why it is helpful and any insights, tips, hints about use of the query or queries and what the data tells you about potential ORA-4031 problems.
For example, on Oracle 8 and higher, there is a view to breakdown actual memory "health" in the Shared Pool--v$sql_shared_memory.
col alloc_class heading "Allocation"
col total format 999,999,999,999 heading "Total"
col average format 999,999,999.99 heading "Average"
col maximum format 999,999,999 heading "Maximum"
select alloc_class, sum(chunk_size) total, avg(chunk_size) average, max(chunk_size) maximum
from v$sql_shared_memory group by alloc_class
0