Can you tell me the physical size of the data types, including as Date, Number, VARCHAR2? How about physical size...
of an index? Does each index have a ROWID also? Or is ROWID only for the table? I need this information so that I can calculate the size of physical record space occupied.
Oracle sizing can be quite complex. In fact, they have even removed this information from many of the manuals. Generally numeric data is n/2+1 where n is the physical size. Dates are 8 bytes (7 bytes plus a header byte) varchar2 are the actual length plus a header byte, except if you exceed 255 long then they are 2 header bytes, blob, clob are special cases. Char are always the full length specified plus a header byte (they are blank padded).
Indexes are tricky since they store rowid as well as the index data. E-mail me at firstname.lastname@example.org, and I can get you some spreadsheets for sizing.
Dig Deeper on Oracle database design and architecture
Related Q&A from Mike Ault
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists. Continue Reading
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to... Continue Reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.