what fits in one physical block of memory?
Date: Sun, 02 May 1999 01:53:10 GMT
Message-ID: <7ggb65$sk9$1_at_nnrp1.dejanews.com>
Hello everyone,
I'm sorry if this is double posted,or cross posted...
[Quoted] 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 - 03:53:10 CEST