what fits in on physical block of memory?

Hello everyone,
I'm sorry if this is double posted, but when i tried to access "newbie question", i was told "article unavailable", so here it goes again:

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 Sat May 01 1999 - 20:49:08 CDT