Re: Size of overheads of Oracle 7 for Windows NT ?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 14 Oct 1999 21:08:32 +0200
Message-ID: <939928124.18115.0.pluto.d4ee154e@news.demon.nl>

Check out the formulas in appendix A of the Oracle Server Administrators Guide.
If you don't have it, get it from http://technet.oracle.com . With a 2 k block size the usable space in an index block is 1889 bytes and data about the same.

Hth,

--
Sybrand Bakker, Oracle DBA
olivier ALLAIN <oallain_at_celya.fr> wrote in message news:3805D8C5.9B37FCC1_at_celya.fr...
> What is the real size of the overhead of a row of an index with Oracle 7
> under Windows NT 4 ?
> And of a row of a table ?
>
> Is it true in a block the overhead size is 90 bytes ?
>
> Thanx,
>
> Oli
>
Received on Thu Oct 14 1999 - 14:08:32 CDT