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.