From: Bryan Lenihan <bryanle@lenisoft.com>
Subject: Re: Shared Pool Components
Date: 1998/02/02
Message-ID: <6b3mj9$nsi@bgtnsc02.worldnet.att.net>#1/1
Content-Transfer-Encoding: 7bit
References: <01bd2f61$d5c17300$e8a5d6d0@jcarlson>
To: Ray & Janine Carlson <jcarlson@castles.com>
Content-Type: text/plain; charset=us-ascii
Organization: AT&T WorldNet Services
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server



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 !!!