Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8QDAKi30863 for ; Fri, 26 Sep 2003 08:10:20 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8QDAKc30858 for ; Fri, 26 Sep 2003 08:10:20 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h8QAU1i0013618 for ; Fri, 26 Sep 2003 03:31:35 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h8QAFSI9011692 for oracle-l@orafaq.net; Fri, 26 Sep 2003 03:15:28 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D12DB; Fri, 26 Sep 2003 03:14:42 -0800 Message-ID: Date: Fri, 26 Sep 2003 03:14:42 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= Subject: 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=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Was it not Dave Ensor that once concluded that x$ tables actually change less than v$ tables? Tanel Poder wrote: >I'd suggest, when possible, not to use any x$ views, but stich with plain >old documented ways. That way you'll probably avoid a lot of confusion, >especially when database versions might change.. > >Tanel. > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" >Sent: Friday, September 26, 2003 1:19 PM > > > > >>Hi Prem, >> >>I Think you are also doing the same mistake that I have done yesterday, >>that was causing so much confusion. >>I had earlier calculated the library cache and sql area size from X$ksmsp. >>Please check the size of these component in x$ksmss. >>WHat is difference in both x$ view is little bit confusing. >> >>ORACLE try to calcluate SGASTAT from V$SGASTAT based on below mentioned >>query: >>=========== >>select inst_id, >> '', >> ksmssnam, >> ksmsslen >>from x$ksmfs >>where ksmsslen>1 >>union all >>select inst_id, >> 'shared pool', >> ksmssnam, >> sum(ksmsslen) >>from x$ksmss >>where ksmsslen>1 >> group by inst_id, 'shared pool', ksmssnam >>union all >>select inst_id, >> 'large pool', >> ksmssnam, >> sum(ksmsslen) >>from x$ksmls >>where ksmsslen>1 >> group by inst_id, 'large pool', ksmssnam >>union all >>select inst_id, >> 'java pool', >> ksmssnam, >> ksmsslen >>from x$ksmjs >>where ksmsslen>1 >>===================== >>You can see the library cache and sql area size from : >>select inst_id, >> 'shared pool', >> ksmssnam, >> sum(ksmsslen) >>from x$ksmss >>where ksmsslen>1 >> group by inst_id, 'shared pool', ksmssnam >> >> >>=============== >>However at same time when when you you calculate these component from the >>x$ksmsp using below mentioned SQL: >>get different result: >> >> >> >>SQL> l >> select >> ksmchcom contents, >> sum(ksmchsiz) total >> from >> sys.x$ksmsp >> where >> inst_id = userenv('Instance') >> group by ksmchcom >> >> >> >>With Regards, >>Manoj Kumar Jha >>C-56 , Phase-2 >>NOIDA -201305, UP(INDIA) >>Tata Consultancy Services >>Ph No: (+91-120) 4461001 ext : 1037 (Off.) >>Mobile No : 9810090974 >> >>-------------------------------------------------------------------------- >> >> >-------------------------- > > >>A transcendentalist engaged in auspicious activities does not meet with >>destruction either in this world or in the spiritual world; one who does >>good, >>is never overcome by evil. >>-------------------------------------------------------------------------- >> >> >-------------------------- > > >> >> Prem Khanna J >> > >> >list ORACLE-L > > >> .co.jp> cc: >> Sent by: Subject: Re: RE: "SQL AREA" >> >> >and "LIBARARY CACHE" size? > > >> ml-errors@fat >> city.com >> >> >> 09/26/03 >> 01:39 PM >> Please >> respond to >> ORACLE-L >> >> >> >> >> >> >>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). >> >> >> >> >>DISCLAIMER: The information contained in this message is intended only and >>solely for the addressed individual or entity indicated in this message >> >> >and > > >>for the exclusive use of the said addressed individual or entity indicated >>in this message (or responsible for delivery of the message to such >> >> >person) > > >>and may contain legally privileged and confidential information belonging >>to Tata Consultancy Services. It must not be printed, read, copied, >>disclosed, forwarded, distributed or used (in whatsoever manner) by any >>person other than the addressee. Unauthorized use, disclosure or copying >> >> >is > > >>strictly prohibited and may constitute unlawful act and can possibly >>attract legal action, civil and/or criminal. The contents of this message >>need not necessarily reflect or endorse the views of Tata Consultancy >>Services on any subject matter. Any action taken or omitted to be taken >>based on this message is entirely at your risk and neither the originator >>of this message nor Tata Consultancy Services takes any responsibility or >>liability towards the same. Opinions, conclusions and any other >> >> >information > > >>contained in this message that do not relate to the official business of >>Tata Consultancy Services shall be understood as neither given nor >> >> >endorsed > > >>by Tata Consultancy Services or any affiliate of Tata Consultancy >> >> >Services. > > >>If you have received this message in error, you should destroy this >> >> >message > > >>and may please notify the sender by e-mail. Thank you. >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.net >>-- >>Author: ManojKr Jha >> INET: jmanoj@delhi.tcs.co.in >> >>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). >> >> >> > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: mln@miracleas.dk 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).