Oracle9i Database: Performance Tuning (4)

Sizing Other SGA Structures

• The default size of the Large pool is 0, the min value that can be assigned to large_pool_size is 300kb. The size of the large pool ranges from 300kb to 2G

• Query the V$SGASTAT by using pool = large pool will return the amount of Large pool that is free and utilized.