Home » RDBMS Server » Server Administration » Big Datafile vs Multiple Small Datafiles (Oracle 10.2.0.4)
Big Datafile vs Multiple Small Datafiles [message #461402] Thu, 17 June 2010 13:54 Go to next message
mmendezdba
Messages: 2
Registered: June 2010
Location: Puerto Rico
Junior Member
Hi,

Does any one knows what's the difference between having BIG datafile (32GB) vs many small datafiles (4GB) replacing a Big one.

Best Regards

Report message to a moderator

Re: Big Datafile vs Multiple Small Datafiles [message #461403 is a reply to message #461402] Thu, 17 June 2010 14:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Does any one knows what's the difference between having BIG datafile (32GB) vs many small datafiles (4GB) replacing a Big one.
It depends. If the smaller files are all residing on different physical disk drives, then performance will be (somewhat) slower on a single 32GB file.

Report message to a moderator

Re: Big Datafile vs Multiple Small Datafiles [message #461405 is a reply to message #461402] Thu, 17 June 2010 14:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The difference is one vs many.
Apart from that, unless you do not use RMAN to backup and don't want to use 11g, there is no difference.
RMAN 11g can backup part of files in parallel into different pieces.
Otherwise you have to backup the big file serially.

Regards
Michel

Report message to a moderator

Re: Big Datafile vs Multiple Small Datafiles [message #461406 is a reply to message #461403] Thu, 17 June 2010 14:09 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
If the smaller files are all residing on different physical disk drives, then performance will be (somewhat) slower on a single 32GB file.

Is there still someone not using disk array hiding the physical level and not using stripping?

Regards
Michel

Report message to a moderator

Previous Topic: Find SQL history of all executed statements along with user details
Next Topic: user defined database paramters (eg environment variables)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 10:41:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.