Re: Shared Pool Components

From: Bryan Lenihan <bryanle_at_lenisoft.com>
Date: 1998/02/02
Message-ID: <6b3mj9$nsi@bgtnsc02.worldnet.att.net>#1/1

The shared pool consists of the Data Dictionary Cache and the SQL Statement Cache. The values for each and the division for each is controlled by the server processes. The shared_pool_size parameter (from my understanding) specified the total amount of space that is used by the both the SQL area and the Data Dictionary Cache.

Thanks,
Bryan

Ray & Janine Carlson wrote:

> What components make up the Shared Pool? Selecting from v$sgastat gives
> all SGA components - which ones add up to the number of bytes specified in
> the SHARED_POOL_SIZE parameter?
>
> Thanks !!!
Received on Mon Feb 02 1998 - 00:00:00 CST