Home » RDBMS Server » Performance Tuning » increase the Oracle datafile size or add another datafile (Oracle)
increase the Oracle datafile size or add another datafile [message #325837] Mon, 09 June 2008 02:41 Go to next message
arunmdr
Messages: 6
Registered: June 2007
Location: India
Junior Member
Someone please explain,
Is it better to increase the Oracle datafile size or add another datafile to increase the Oracle tablespace size?

Thanks in advance
Re: increase the Oracle datafile size or add another datafile [message #325844 is a reply to message #325837] Mon, 09 June 2008 03:04 Go to previous message
Michel Cadot
Messages: 64418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on what you have below disks and so on.
If you create the other data file on the same disk there is no difference in performances.
The question is then what is the max size you are able to backup in one shot.

Regards
Michel
Previous Topic: Partitioning decision
Next Topic: Parallel hint
Goto Forum:
  


Current Time: Sun Feb 19 12:59:44 CST 2017

Total time taken to generate the page: 0.08786 seconds