RE: TABLE CACHE

It will take the same amount of memory that it currently is taking in disk space. You will need to increase your cache until it is at least as large as the number of blocks that are in the table. If you are running Oracle 8, then there is a new feature that allows you to assign specific pools to your tables rather than using the CACHE parameter. The feature requires configuration of the init.ora to set aside a KEEP and a RECYCLE pool. You then add a POOL KEEP or a POOL RECYCLE command to the create table.

I would question the practice of keeping a large table in memory, however. How big is "large"? Oracle already handles caching of the table by cycling the disk blocks throught the DB_BLOCK_BUFFERS. If the table is too large, you may start thrashing your memory with pages and swaps if you get too many users.

> -----Original Message-----
> From: mala singh [SMTP:mala_singhm_at_hotmail.com]
> Sent: Wednesday, February 07, 2001 11:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: TABLE CACHE
>
> Hi DBAs
> I have one large table.I want to keep it into memory thru
> alter table <tname> 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.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mala singh
> INET: mala_singhm_at_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_at_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_at_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_at_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).