Re: Size of a single Record ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Apr 2005 05:51:06 -0700
Message-ID: <1113396666.839907.106090@g14g2000cwa.googlegroups.com>

If you generate statistics on the table then you can get the average row size including Oracle row overhead from dba_tables.avg_row_len. Row overhead would be the 3 byte row header and the length bytes of the columns.

For the size of a specific row you would have to retrieve it and use the lengh(col) function to add up the length of the data but this length would not include row overhead.

select length(col1) + length(col2) + ... length(colN) from ...

The total space allocated to a table can be found in the dictionary views all_, dba_, user_segments or all_, dba_, or user_extents. See the Oracle version# Reference Manual for information on any rdbms dictionary view.

HTH -- Mark D Powell -- Received on Wed Apr 13 2005 - 07:51:06 CDT