what fits in one physical block of memory?

From: <setwhite_at_indiana.edu>
Date: Sun, 02 May 1999 07:52:33 GMT
Message-ID: <7gh080$ct7$1_at_nnrp1.dejanews.com>

Hello everyone,
I'm sorry if this is double posted,or cross posted...

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.

Can people help me out by suggesting a large number of records that will fit in one block? I dont need to know the absolute largest the table can get. I just need an idea of a very very large number of INT records that will definetly fit in one physical block of memory.

Right now i am limiting the table to 50 records, because I am new to Oracle, but the larger I can grow the median table, the more interesting my results will be to my professor types.

Surely there is a number larger than 50 that could safely use?

Any informed guess would be greatly appreciated, and please feel free to email me on this one.

thanks,

seth white

setwhite_at_indiana.edu

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun May 02 1999 - 09:52:33 CEST