Oracle Internals (Overhead)

Hi All,

I'm trying to do some sizing estimates for a project and need to know something about how Oracle stores its data:

1. We have some fields that are unsigned integer values between 0 and 255. Can Oracle store these in a single byte, or is there a 2-byte (or even a 4-byte) minimum for integers?
2. What is the number of bytes required to store a Date field? Is this the same whether it's just a date or whether it's date with time information?
3. If we have a varchar2 field, what is the number of overhead bytes required for the field length information (e.g. is it a two-byte length, a one-byte terminator, or something else)?
4. If we have a long raw field, what is the number of overhead bytes required to store the field?
5. What is the number of overhead bytes per row stored in the database?

Also, if anyone knows of a reference that has this type of info I'd appreciate it.

TIA, Sid Gudes
cougar_at_road_runner.com
ANTI-SPAM: remove "_" after "road" when replying Received on Tue Feb 10 1998 - 00:00:00 CST