Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Mark D Powell" <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Size of a single Record ?
Date: 13 Apr 2005 05:51:06 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <1113396666.839907.106090@g14g2000cwa.googlegroups.com>
References: <1113394165.896480.95880@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 192.85.50.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1113396671 2796 127.0.0.1 (13 Apr 2005 12:51:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 13 Apr 2005 12:51:11 +0000 (UTC)
In-Reply-To: <1113394165.896480.95880@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=192.85.50.2;
   posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:240279

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 --