OraFAQ Forum: Server Administration » Data File size in UNDO Tablespace 380 GB

Home » RDBMS Server » Server Administration » Data File size in UNDO Tablespace 380 GB (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data File size in UNDO Tablespace 380 GB [message #381809]

Tue, 20 January 2009 00:08

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.

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #381811 is a reply to message #381809]

Tue, 20 January 2009 00:23

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

Which OS you are using for this ? (64 bit or 32 bit).

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #381813 is a reply to message #381811]

Tue, 20 January 2009 00:30

vboppa
Messages: 22
Registered: November 2008

Junior Member

Sun Solaris 10 64 bit

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #381820 is a reply to message #381809]

Tue, 20 January 2009 00:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

UNDO size depends on your workload not on database size.

Regards
Michel

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #382664 is a reply to message #381820]

Fri, 23 January 2009 09:28

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.

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #382669 is a reply to message #382664]

Fri, 23 January 2009 09:39

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.

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #382673 is a reply to message #382669]

Fri, 23 January 2009 09:47

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

Report message to a moderator

Re: Data File size in UNDO Tablespace 380 GB [message #382683 is a reply to message #382669]

Fri, 23 January 2009 10:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 18:02:26 CST 2024