Quote Originally Posted by SandLake
Excuse me for being dim but how does a 4K block size give you 121 extents?
I got the number from memory. It looks like a 2K block size will allow you to have 121 extents. a 1K block size will allow only 57 extents.

I found this online, this should help you to understand where the numbers come from. You really need to get this upgraded, and soon.

"Extent maps: In the header of every type of segment, there is an extent map, a list of all extents, including the data block address of the first block and their length in blocks. Until Oracle7 v7.3, this extent map was limited to a single database block itself, requiring limits on the size of the extent map based on the database block size."

http://www.evdbt.com/MythsExtPerf.doc