Re: size of a row

From: <rgaffuri_at_cox.net>
Date: Mon, 04 Aug 2003 04:49:29 -0800
Message-ID: <F001.005C8CD6.20030804044929@fatcity.com>

use dba_tables
avg_row_len

there are ways to calculate it pretty close. I saw some papers on the web that tell you how much storage space each data type uses. but there is also row level overhead. I think that is described on metalink.

avg_row_len is usually enough.
>
> From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen_at_cetelem.fr>
> Date: 2003/08/04 Mon AM 06:54:26 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: size of a row
>
> Hi list,
> sorry because the question is certainly already posted :
> How can I calculate a size of one row in my Table ?
> Thanks in advance!
> Philippe
>
>

Hi list,
sorry because the question is certainly already posted :
How can I calculate a size of one row in my Table ?
Thanks in advance!
Philippe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Aug 04 2003 - 07:49:29 CDT