I am new for oracle- please help.
env.- Oracle 8.0.5- archive mode.
Last week we had experienced space issue and we added 1 disk (say diskdrive-M) and then allocated 2 datafiles, one for indx tablespace and another for Data tablespace.
Disk-M is not as powful as the other disks on the server. Now I need to remove this slow disk and replace a new, powerful disks (same as the others on the server). Any suggestion for how to get this done?
one thing couldn't get out of my mind is that before we added diskdriver-M, we don't have any performance issue. after diskdrive-M was added, system has been slow down since then. I don't think we are writing any data into diskdrive-M at all. (maybe I am wrong - any way to check out have those datafiles been used?) If they are not being used at all, can I drop them????