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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.193.108