-
Oracle server setup
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
-
Re: Oracle server setup
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
on harddisk 1 What tablespace you refering to? Are there non sys/system objects store at system tablespace?
-
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
Last edited by sfdba; 03-12-2004 at 04:41 AM.
-
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....
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|