Home » RDBMS Server » Server Administration » Data File size in UNDO Tablespace 380 GB (oracle 9i)
Data File size in UNDO Tablespace 380 GB [message #381809] Tue, 20 January 2009 00:08 Go to next message
vboppa
Messages: 22
Registered: November 2008
Junior Member
We are planning to create 65 TB of DB. It is a semi OLTP and OLAP DB, 380 GB (is suffiecient for UNDO?) is allocated for UNDO tablespace, how many datafiles are needs to be specified for UNDO Tablespace and what is the size for each datafile?

Thanks.
Re: Data File size in UNDO Tablespace 380 GB [message #381811 is a reply to message #381809] Tue, 20 January 2009 00:23 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
Which OS you are using for this ? (64 bit or 32 bit).

Re: Data File size in UNDO Tablespace 380 GB [message #381813 is a reply to message #381811] Tue, 20 January 2009 00:30 Go to previous messageGo to next message
vboppa
Messages: 22
Registered: November 2008
Junior Member
Sun Solaris 10 64 bit
Re: Data File size in UNDO Tablespace 380 GB [message #381820 is a reply to message #381809] Tue, 20 January 2009 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UNDO size depends on your workload not on database size.

Regards
Michel
Re: Data File size in UNDO Tablespace 380 GB [message #382664 is a reply to message #381820] Fri, 23 January 2009 09:28 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
UNDO size depends on the application workload, but UNDO datafile size is a different matter.

From Metalink Doc 336186.1 the maximum datafile size in 10gR2 is 2^22 blocks, or 32Gb for a database with an 8k block size.

12 32Gb data files should do the job.
Re: Data File size in UNDO Tablespace 380 GB [message #382669 is a reply to message #382664] Fri, 23 January 2009 09:39 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I just noticed that you're using 9i.

I can't find the maximum file size on 9i. I'll keep looking.
Re: Data File size in UNDO Tablespace 380 GB [message #382673 is a reply to message #382669] Fri, 23 January 2009 09:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Here we go: Metalink doc 217143.1

Not terribly informative. Basically, it's the OS maximum file size, which is ususally 2^22 Blocks, as for 10G
Re: Data File size in UNDO Tablespace 380 GB [message #382683 is a reply to message #382669] Fri, 23 January 2009 10:14 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reference
Chapter 4 Database limits
Section Physical Database Limits

Quote:
Database file size
Maximum
Operating system dependent. Limited by maximum operating system file size; typically 2^22 or 4M blocks


It is true for all versions (for small file) as block number is on 22 bits in rowid.

Regards
Michel
Previous Topic: Unable to find out the SCN to perform the incompete recovery (merged)
Next Topic: Problem with Temporary Tables
Goto Forum:
  


Current Time: Wed Dec 07 22:44:34 CST 2016

Total time taken to generate the page: 0.18846 seconds