Re: automatic extent allocation
- From: Jared Still <jkstill@xxxxxxxxx>
- To: mark.powell@xxxxxxx
- Date: Fri, 7 Jan 2005 13:37:22 -0800
On Fri, 7 Jan 2005 16:09:45 -0500, Powell, Mark D <mark.powell@xxxxxxx> wrote:
> From the version 9.2 Reference Manual:
> Maximum
> Unlimited
>
> I was thinking that "Unlimited" actually corresponds to 2 billion. In any
> case it is a lot and probably more than enough for most shops.
>
... which allows for a 16 TB table with an 8k block size.
Or if using the drive manufacturers prefferred decimal notation, 17.5 TB.
Probably enough for most tables.
So, why extent limits determined with a 31 bit number?
Rather than a 32 bit one that is.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
