Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g max datafile sizes

Re: 10g max datafile sizes

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 20 Dec 2007 13:23:50 -0800 (PST)
Message-ID: <e4cb8add-7837-4151-aa3e-b60a06ba4846@q3g2000hsg.googlegroups.com>


On Dec 20, 4:11 pm, sybra..._at_hccnet.nl wrote:
> On Thu, 20 Dec 2007 09:35:40 -0800 (PST), Ben <benal..._at_yahoo.com>
> wrote:
>
> >10.2.0.2 AIX5.2
>
> >I was trying to figure out what the maximum size was for datafiles in
> >a non bigfile tablespace. I found the following thread on here
> >http://tinyurl.com/2bm3ngand it lead me to the Physical Database
> >Limits page in the documentation.
>
> >Am I understanding this correctly that basically a datafile maxsize is
> >limited by the size of the database blocks that are being used? So if
> >my database is setup for 8K blocksize, then I'm limited to a maximum
> >of 32G datafiles? I don't see where it is different between smallfile
> >and bigfile tablespaces. Would you need to setup a bigfile tablespace
> >with a nonstandard blocksize to accomplish > 32G datafiles?
>
> Recovery time anyone?
>
> And a bigfile tablespace can only have 1 datafile ever.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I do not remember the size range but with a bigfile tablespace you can support at least 128T datafile. That should take a while to backup and recover.

Meanwhile a smallfile tablespace can have up to 1022 32G files (if 8k).
That should be enough space for most sites.

Received on Thu Dec 20 2007 - 15:23:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US