Hi,
I am migrating an 8.0.5 databse on NT to 64 bit 8.1.7 databse on AIX 4.3.3 . This IBM Server has 8GB of memory expandable to 16GB.
The aim is to cache i/o intense data in memory.
Is it a good idea to cache tables of size 500MB, 1GB in SGA.?
How is cache handled internally ? What's the syntax for caching a table. My my understanind id that caching has to be specified at table create time.
Is there any way to cache an already created table ?
Is there also any way to uncache an already cached table ??
Please help


Thanks,
Geo