DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Oracle server setup

  1. #1
    Join Date
    Jan 2002
    Posts
    40

    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

  2. #2
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116

    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?

  3. #3
    Join Date
    Jan 2002
    Posts
    40
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  5. #5
    Join Date
    Jan 2002
    Posts
    40
    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look for 'move datafiles on tahiti.oracle.com

    it eill be take tsbalespace offline, copy the os file, move the file in the dictionary

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You're running an ERP database on a "server" with two 6.5Gb disks?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hard Disks are cheap these days, buy more disk space....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width