O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required