Home
Trouble shooting
 

Cry about...
Oracle Troubleshooting

Excessive Disk Activity

Symptom:

Excessive disk activity.

Possible Causes and Remedies:

There are a number of likely causes of excessive disk activity:

  1. Poor database tuning. Is the database properly tuned? Excessive disk activity may be a symptom that Oracle has been allocated insufficient memory.

  2. Heavy database usage. This is characterised by lots of reads or writes to the tablespace datafiles. Consider whether the organisation of tablespace files across disks could be improved.

  3. The system is swapping. If there is much page file usage on the server then this indicates that there is either insufficient physical RAM or that Oracle has been allocated too much memory to use.

  • Consider reducing DB_BLOCK_BUFFERS until swapping stops.

  • Consider increasing the amount of physical RAM on the server.