Monitoring the Shared Pool
The Oracle shared memory area is called the System Global Area (SGA). After the buffer cache, the shared pool is typically the largest component of the SGA.
The shared pool includes memory for the library cache, which caches information about database objects such as stored procedures and views, the cursor cache, which caches SQL statements and, if the Shared Server (previously known as the MultiThreaded Server, or MTS) is in use, a cache for session-specific information such as the context area and the sort area.
If the shared pool is too small, performance can suffer. It can be increased with the shared_pool_size parameter in init.ora. To monitor the shared pool, run the following statements as sysdba:
select value ...Get Configuring and Tuning Databases on the Solaris™ Platform 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.
