RE: Max Extents Question

Do your math again!
2,147,483,645 times 8,096 = 17,386,027,589,920 or if you prefer: (2 x 10^9 ) * ( 8 x 10 ^3 ) = 16 * 10^12 That is 16 terabytes. So now you know what a terabyte is.

Cheers!

On Mon, 6 Nov 2000 renato.huliganga_at_au1.ibm.com wrote:

>
>
> On 11/07/2000 06:41:55 AM bsilverio_at_necc.mass.edu said
>
> >Assuming an 8k block size, the table is 17,386,027,589,920 bytes.
> >That is a 17 Terrabyte table.
>
> According to my calculations (base 2) his table is 16,192 gigabytes! I do
> not know how much a terabyte is, because it is not used commonly yet.
> However, putting this quantity in more commonly used measurements:
>
> at 40 Gb per disk (I just bought one for my home PC) nowadays, that table
> would be using at least 405 of them. Now it does not look much does it?
>
> Cheers,
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: renato.huliganga_at_au1.ibm.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Nov 06 2000 - 20:24:59 CST