These views provide information about the System Global Area:
Lists the number of increased buffer misses if the value of DB_BLOCK_BUFFERS were to be reduced. See the INIT.ORA parameter DB_BLOCK_EXTENTED.
Lists the number of increased buffer hits if the value of DB_BLOCK_BUFFERS were to be increased. See the INIT.ORA parameter DB_BLOCK_LRU_EXTENDED_STATISTICS.
Contains information about the size, in bytes, of each of the various SGA components.
Provides more detailed information about SGA utilization than V$SGA. Shows the breakdown of the SHARED_POOL and LARGE_POOL areas.
Contains statistics about the SHARED_POOL area of the SGA. Some of the columns are meaningful only if the INIT.ORA parameter SHARED_POOL_RESERVED_SIZE has been set.