Re: "Headroom" in datafiles?

From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 16 Sep 2009 23:05:13 -0700
Message-ID: <a9c093440909162305r5e7f8efepca8706eb9fe31af1_at_mail.gmail.com>

bigfile _at_8k has max 32TB
smallfile _at_8k has max 32GB

On Wed, Sep 16, 2009 at 11:01 PM, hrishy <hrishys_at_yahoo.co.uk> wrote:
> Hi
>
> Are the docs wrong ?
>
> http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/tspaces..htm#i1010733
>
> quote
> A bigfile tablespace with 8K blocks can contain a 32 terabyte datafile
> quote
>
> My impression is that for 8k block size the size of the datafile is 32gb

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 17 2009 - 01:05:13 CDT