Printable View
Hello everybody,
My Oracle server consists of 2 hard disks of 6.5 GB each. On harddisk one the oracle server (plus tablespaces) is loaded, whereas on harddisk 2 only Data and Index tablespace is allocated. My problem is that my first harddisk is almost full (only 34 MB remaining) and because of which I believe that the overall ERP software has become very slow. What do I do in this case? Right now i cant afford to go in for a new high capacity server....
Thanks,
SFDba
on harddisk 1 What tablespace you refering to? Are there non sys/system objects store at system tablespace?Quote:
Originally posted by sfdba
Hello everybody,
....On harddisk one the oracle server (plus tablespaces) is loaded, whereas on harddisk 2 only Data and Index tablespace is allocated
well originally the whole server plus all the tablespace were on Hard disk 1 only. When there was a need to add datafiles these data files were configured on Hard disk 2 due to space constraints. I have about 5 GB free space on harddisk 2....No there are no non sys/system objects in system tablespace
Are you sure it is slow due to the hard disk and not something else?
If you need to you can move datafiles from one disk to the other
Hi Davey, yeah I have check all other parameters and sure that its due to hard disk space problem. I want to transfer the datafiles on the 2nd hard disk....can u guide me how to do it....or just tell me if the following steps are correct:
Steps to transfer datafile on the second hard disk:
(1) Shut down the oracle database useing SvrMgr
(2) Shift the data file from one harddisk to another
(3) Re-configure the path of the datafile in the tablespace and start the database again.
Thanks
Sfdba
look for 'move datafiles on tahiti.oracle.com
it eill be take tsbalespace offline, copy the os file, move the file in the dictionary
You're running an ERP database on a "server" with two 6.5Gb disks?
Hard Disks are cheap these days, buy more disk space....