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
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: 22526
Registered: January 2009
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
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: 58616
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
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: 4403
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.
Previous Topic: Resource Manager
Next Topic: Is tablespace size required to increase
Goto Forum:
  


Current Time: Wed Jul 30 02:42:30 CDT 2014

Total time taken to generate the page: 0.12559 seconds