SGA
These views provide information about the System Global Area:
- V$CURRENT_BUCKET
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.
- V$RECENT_BUCKET
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.
- V$SGA
Contains information about the size, in bytes, of each of the various SGA components.
- V$SGASTAT
Provides more detailed information about SGA utilization than V$SGA. Shows the breakdown of the SHARED_POOL and LARGE_POOL areas.
- V$SHARED_POOL_RESERVED
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.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.