Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8Q9nPZ20026 for ; Fri, 26 Sep 2003 04:49:25 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8Q9nPc20019 for ; Fri, 26 Sep 2003 04:49:25 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8Q7AUB03215 for oracle-l@orafaq.net; Fri, 26 Sep 2003 00:10:30 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D117B; Fri, 26 Sep 2003 00:09:43 -0800 Message-ID: Date: Fri, 26 Sep 2003 00:09:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Prem Khanna J Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Prem Khanna J Subject: Re: RE: "SQL AREA" and "LIBARARY CACHE" size? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Manoj, this is the statistics i got from one of my instance. sql area 225 MB library cache 112 MB I was also confused as u were [ i didn't notice this so far ]. but reading the replies of Tanel & Steve once again: But what Steve meant (please correct me if I'm wrong), is that operations on sql areas are managed by library cache structures (library cache latch, KGL manager, lib cache hash table, etc), so sql area is dependent on library cache, despite the fact they both have memory allocated directly from shared pool. from this (and as per the docs) i understand that sql area is a subset of library cache. perhaps,what "subset" means is: in terms of the control library cache has over sql area and not in terms of memory allocated. is my understanding correct, Tanel ? My best guess at the moment is that when new recreatable chunks are first unpinned, they go onto the transient list, and then when they have been reused, they go back onto the recurrent list. ..and reading this post by Steve,i feel there is something more(a lot) that we need to know/understand to discuss about this. Can Steve/Tanel/List explain me what is transient chunk & recurrent chunk ? Regards, Jp. P.S.Thanx Naveen. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: jprem@kssnet.co.jp Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).