The server configuration: 64 gb of physical memory;
The oracle install 32-bit, memory management is manual, all is the default installation, the oracle memory using 1.5 G;
Server using frequent oracle, speaking, reading and writing disk usage is too big, almost hard to move, can not use too much memory;
How do I solve;

CodePudding user response:

To see whether the disk is main reading or writing
If it is written, and memory did not matter much
If they are read, first check the related SQL statement if there is a large optimization space, otherwise may be appropriately expand the Buffer Cache, need to reinstall the database into a 64 - bit version of the

Now few people in the production environment installed 32 bit oracle...