Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Memory based tables

Re: Memory based tables

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 19 Jul 2005 18:04:51 -0400
Message-ID: <cd4305c105071915047d1f2a95@mail.gmail.com>


Hi Florian,
If you are not using all tablspaces block sizes.

I think you could try to create tablespace 16k or 8K or 4k for example (one you are not using), and thre
create the table there, and only that table will use the blocksize_16k cache memory.

Now if you have problems with redo logs, set as nologging.

Honeslty I think you can get all what you want, the point is don't try to get the solution exactly as you want to find, there are other resources and tricks.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 19 2005 - 17:07:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US