Home » RDBMS Server » Server Administration » max datafile size in Unix/Windows
max datafile size in Unix/Windows [message #285788] Wed, 05 December 2007 11:23 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
All ,

What is the standard datafile size you use in production(very large) environment ?Even i had a environment where we had all datafile size of 2GB each .

i read somewhere the file size shoudl be maximum 1GB for easy managebility and good perfomance .How far is this true ?

Its a generic question .Thnx in advance
Re: max datafile size in Unix/Windows [message #285790 is a reply to message #285788] Wed, 05 December 2007 11:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>What is the standard datafile size you use in production(very large) environment ?
Quantify "very large".
What is the size of the largest tablespace?
How many datafiles do you want to comprise the largest tablespace?
If the largest tablespace is only 2 TeraBytes how many files do you want to support for this tablespace?

IT DEPENDS!
Re: max datafile size in Unix/Windows [message #285791 is a reply to message #285788] Wed, 05 December 2007 11:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It was true 10 years ago.
Now it depends only on your backup devices.

Regards
Michel

[Updated on: Wed, 05 December 2007 12:31]

Report message to a moderator

Re: max datafile size in Unix/Windows [message #285795 is a reply to message #285788] Wed, 05 December 2007 11:47 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thnx Michel/anacedent
Re: max datafile size in Unix/Windows [message #286378 is a reply to message #285790] Fri, 07 December 2007 04:12 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
anacedent wrote on Thu, 06 December 2007 00:34

>
Quantify "very large".

How many datafiles do you want to comprise the largest tablespace?
If the largest tablespace is only 2 TeraBytes how many files do you want to support for this tablespace?

IT DEPENDS!


No, it has the bound size. I am runing Oracle 10g in Solaris. And, the max size of tablespace USERS which contain all of datafiles is to 60GB. The value (60GB) is shown by TOAD.

And now, we have one problem, the tablespace USERS has size 40GB.



Previous Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Next Topic: how to change spfile parameter name
Goto Forum:
  


Current Time: Sun Dec 11 08:28:42 CST 2016

Total time taken to generate the page: 0.21194 seconds