From Patrick.Elliott@bestbuy.com Thu, 08 Feb 2001 12:08:02 -0800 From: "Elliott, Patrick" Date: Thu, 08 Feb 2001 12:08:02 -0800 Subject: RE: TABLE CACHE Message-ID: MIME-Version: 1.0 Content-Type: text/plain I think we are understanding your question. The answer simply is that RAM use equals disk use. The size of your table on disk is what it will need in memory. > -----Original Message----- > From: mala singh [SMTP:mala_singhm@hotmail.com] > Sent: Thursday, February 08, 2001 1:21 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: TABLE CACHE > > Hi Oli > My question is how to compute memeory require by table. > Regards > -Mala > > > >From: Oliver Artelt > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >Subject: Re: TABLE CACHE > >Date: Wed, 07 Feb 2001 13:34:44 -0800 > > > >Hi > > > >select blocks from dba_segments where segment_name ='' shows the > >size > >of your table. > > > >oli > > > >On Wednesday 07 February 2001 19:54, mala_singhm@hotmail.com wrote: > > > Hi DBAs > > > I have one large table.I want to keep it into memory thru > > > alter table cache; > > > Is there any computation formula how much ram this table takes. > > > Please help me.Thanks in advance. > > > Regards > > > -Mala > > > > > > > >_________________________________________________________________________ > > > Get Your Private, Free E-mail from MSN Hotmail at > >http://www.hotmail.com. > > > >-- > >--- > > > >Oliver Artelt, System- und Datenbankadministration > >--------------------------------------------------------------- > > cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg > >telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 > > email: oli@cubeoffice.de # web: http://www.cubeoffice.de > >--------------------------------------------------------------- > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Oliver Artelt > > INET: oli@md.transnet.de > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >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). > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mala singh > INET: mala_singhm@hotmail.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com -- Author: Elliott, Patrick INET: Patrick.Elliott@bestbuy.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).