Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High disk usage on DB server

435383Jun 20 2007 — edited Jun 20 2007

Hi All,

I have 4 four disks connected to my db server and on disk2, I found very high usage (above 90%) every time. I have only one tablespace BME_DATA on this disk and it has only one datafile.

There are only few tables (less than 50) that are stored in this tablespace but most of them are very huge in size (~ 500MB), and yes most of them have high DML activity also.

I am planning to create another datafile for BME_DATA on DISK3 so that load can be balanced. Please suggest if there is any better way to do the same.

Thanks for your interest.
Bhupinder

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2007

Added on Jun 20 2007

#general-database-discussions

10 comments

1,146 views