Home » RDBMS Server » Server Administration » What can be the maximum size of Data file (Oracle 11G R2 (11.2.0.1), Windows 2003 32 bit)
What can be the maximum size of Data file [message #532814] Thu, 24 November 2011 22:14 Go to next message
saikumar_mudigonda
Messages: 23
Registered: June 2008
Location: hyderabad
Junior Member
All,

I am having I/O issues if i create 20 GB DATAFILES on SMALL TABLE SPACE.

can you please guide me with the maximum size limit of data file that I can create in Windows 2003 32 bit server.

thanks,
Sai Kumar

Report message to a moderator

Re: What can be the maximum size of Data file [message #532815 is a reply to message #532814] Thu, 24 November 2011 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can you please guide me with the maximum size limit of data file that I can create in Windows 2003 32 bit server.
problem & solution has nothing to do with Oracle RDBMS

Report message to a moderator

Re: What can be the maximum size of Data file [message #532823 is a reply to message #532814] Thu, 24 November 2011 23:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you mean size of an Oracle data file:
Database Reference
Annex A Database Limits
Section Physical Database Limits

Regards
Michel

Report message to a moderator

Re: What can be the maximum size of Data file [message #532831 is a reply to message #532814] Fri, 25 November 2011 01:23 Go to previous message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
32G if you use 8K blocks, 64G if you are using 16K blocks, and so on. That is the DB_BLOCK_SIZE, not the file system block size. The limit comes from the structure of the ROWID. Big file tablespaces use a different rowid structure, and the limit is astronomical.

Report message to a moderator

Previous Topic: Resource Manager
Next Topic: Is tablespace size required to increase
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 00:36:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.