Re: 10g max datafile sizes

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.

• Mark D Powell --