OraFAQ Forum: Server Administration » adding extra hard drive to my server

Home » RDBMS Server » Server Administration » adding extra hard drive to my server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

adding extra hard drive to my server [message #388199]

Mon, 23 February 2009 15:58

kinansy
Messages: 3
Registered: February 2009

Junior Member

Oracle R2 is installed, and the installation is OFA-compliant where
• ORACLE_BASE = C:\oracle
• ORACLE_HOME = C:\oracle\ora92

****
Suppose an extra hard drive (D:) is added to my server
-What are the required changes to my database to increase its performance and availability?
-What are required instructions to accomplish these changes?

Oracle 9i

Report message to a moderator

Re: adding extra hard drive to my server [message #388200 is a reply to message #388199]

Mon, 23 February 2009 16:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>-What are the required changes to my database to increase its performance
May be you can distribute the i/o between the disks by placing datafiles on different disks. But if you are talking about just 2 disks in a pc (no raid etc), there is nothing much you can get out of it.
>>and availability?
Define ***availability*** in your terms.
In my terms, availability applies to the whole database and will involve at least one more node (for failover).
Just adding another disk helps nothing in real world.

[Updated on: Mon, 23 February 2009 16:53]

Report message to a moderator

Re: adding extra hard drive to my server [message #388247 is a reply to message #388200]

Tue, 24 February 2009 00:36

kinansy
Messages: 3
Registered: February 2009

Junior Member

Mahesh Rajendran wrote on Mon, 23 February 2009 16:37

>>-May be you can distribute the i/o between the disks by placing datafiles on different disks.

Thanks for your cooperation..

If That's right ... How can i do it (as system operator).

Regards

Report message to a moderator

Re: adding extra hard drive to my server [message #388445 is a reply to message #388247]

Tue, 24 February 2009 16:50

varunvir
Messages: 389
Registered: November 2007

Senior Member

YOu need not to be system operator to place datafiles on
different disks.You can do it if you are DBA.
Please define the path of datafiles on different disks while
creating tablespaces to achieve this.
Regards,
Varun Punj,

Report message to a moderator