Re: Lob Segment limits

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 22 Apr 2005 09:09:15 +0100
Message-ID: <7765c89705042201096878a267@mail.gmail.com>

On 4/21/05, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
>
> There is small and a very useful booklet called Oracle Reference. It
> contains section called "Database Limits".
>

My favourite documentation bug, it contains a rather severe limit on the size of your database (at least on windows and in versions prior to 10)

*Table 7-6 Maximum Number of Extents for Each Database* *Typical Block Sizes* *Number of Extents*

2 KB

121

4 KB

255

8 KB

504

16 KB

1032

32 KB

2070

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 22 2005 - 04:13:27 CDT