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

Report message to a moderator

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: 68664
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 22 21:33:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.