Re: what fits in on physical block of memory?

Assume a platform which supports a 32K block size Knock off about 150 bytes for block and transaction overhead, and assume you pack the block as tightly as possible.

Oracle reserves a minimum of 12 bytes for a row, even if the row is completely null. Subtraction and division left as an exercise for the user.

If you want to vary the figures, Oracle requires 5 bytes per row for row overhead, then a typical (n/2)+1 bytes per integer, where N is the number of digits precision.

Having said that, the expression

    'it will only take Oracle one memory access ...' could be somewhat open to re-interpretation.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

setwhite_at_indiana.edu wrote in message <7ggauk$sa0$1_at_nnrp1.dejanews.com>...
>I need to know how large i can grow this table:
>create table median(salary int);
>and still have it fit into one physical block of memory.
>
>This is an academic (read college) question, which explains why median has
no
>key. I have to do a complexity analysis based on the premise that it will
only
>take Oracle one memory access to read the entire median table.
>
Received on Sun May 02 1999 - 03:56:35 CDT