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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
