Re: Cache a whole database in memory

You can indicate that each table should be cached by doing an alter table xxx cache;
spool cachetabs.sql
select 'alter table '||owner||'.'||table_name||' cache;' from dba_tables order by owner,tablename;
spool off
_at_cachetabs.sql

Also increase the db_block_buffers in the init.ora file to be large enough to actually hold everything.(1 block buffer = 1 database block size so the units are NOT in bytes.)

You really should look at reducing logical IOs to increase performance. Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"news" <jbfidelia_at_multicorpora.ca> wrote in message
news:QGrAa.25981$Fq4.181814_at_weber.videotron.net...


> Hi there,


>

> Does somebody knows if there is a way to configure an Oracle server so it

> caches (or attempt to) all the database tables in memory to process

 queries.


> The purpose of it is to increase performances as memory space is not an


> issue for us.

>

> Thank you

>

> JB.

>

>