Oracle9i not using main memory
Posted on 2006-04-03
I have the following scenario:
Oracle 9i is installed in machine with 2 AMD processors (1.3GHz each). 2GB RAM. Linux OS. 200 GB Hard Disk.
Oracle is running but is NOT using the main memory. When we do bulk load or any db operation oracle prefers
not to use the main memory but the read/write operations are very slow. Oracle is damn slow.
Why? Why oracle doesn't use the main memory?