Doc

Name: SHAREDPOOL.sql

Author: Mahnho Han

Percentage of free space in the SGA shared pool area

This percentage should not drop below 5%

#

TTITLE 'Percentage of free space in the SGA shared pool area'

select round((sum(decode(name, 'free memory', bytes, 0)) /

sum(bytes)) * 100,2)

from v$sgastat;