Home » RDBMS Server » Server Administration » adding extra hard drive to my server
icon5.gif  adding extra hard drive to my server [message #388199] Mon, 23 February 2009 15:58 Go to next message
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
Re: adding extra hard drive to my server [message #388200 is a reply to message #388199] Mon, 23 February 2009 16:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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
Re: adding extra hard drive to my server [message #388445 is a reply to message #388247] Tue, 24 February 2009 16:50 Go to previous messageGo to next message
varunvir
Messages: 363
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,
Re: adding extra hard drive to my server [message #388523 is a reply to message #388445] Wed, 25 February 2009 03:03 Go to previous messageGo to next message
kinansy
Messages: 3
Registered: February 2009
Junior Member
I mean the scripts that i should execute them to do it ..

Thanks
Re: adding extra hard drive to my server [message #388630 is a reply to message #388523] Wed, 25 February 2009 13:22 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
That would be the copy command that is appropriate for your operating system and the Oracle ALTER DATABASE command. There are no scripts.
Previous Topic: Oracle Single Table Hash Clusters (merged)
Next Topic: Move datafile from One location to another
Goto Forum:
  


Current Time: Mon Dec 05 11:19:03 CST 2016

Total time taken to generate the page: 0.19191 seconds