
Monitoring Oracle Resources
Often you will need to monitor caches in the Oracle SGA to find the quality of the buffer areas. The following three areas in the SGA are the most critical. Oversizing these memory areas could result in poor system performance. More space allocated to the SGA means that less resources are available to other Oracle and non-Oracle processes.
See also:
Monitoring the Data Buffer (Oracle)
Monitoring the Shared Pool (Oracle)
Monitoring the Redo Log Buffer (Oracle)