Memory Architecture (contd )
- Oracle 8 supports multiple sub-pools :
KEEP Cache : for small tables required frequently.
RECYCLE Cache : for large tables accessed randomly (low probability of reuse).
DEFAULT : for neither of above. Works like buffer pool of oracle 7.0.
Use Buffer-Pool clause in CREATE TABLE to indicate preferred pool for the table.
- Large buffer cache : good for OLTP but not for Data warehousing where full table scans are common (on summary tables). This is not true for star schemas where indexes are often used for random access.