Oracle-L: Re: RE: size of a row

From: <rgaffuri_at_cox.net>
Date: Mon, 04 Aug 2003 06:19:22 -0800
Message-ID: <F001.005C8CFB.20030804061922@fatcity.com>

vsize seems to only give the number of characters. i think the guy was asking for how many bytes in each row. do you know how to calculate that? I know there are papers out there that tell you how many bytes different datatypes take up, but how do you find out about how many bytes are in a row header or is it a standard size?

if you want to calculate how many bytes in a row is just bytes of data plus row header? or is there more to it?
>
> From: "Goulet, Dick" <DGoulet_at_vicr.com>
> Date: 2003/08/04 Mon AM 09:54:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: size of a row
>
> Philipee,
>
> I assume your looking for the real rowsize, therefore the way to find it is
>
> select sum(vsize(column1)+vsize(column2)+..... ) from <table_name>;
>
> Now if you have nullable columns you need to either not include them in the report or use the nvl function on them.
>
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Monday, August 04, 2003 6:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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
>
>
>

size of a row

Philipee,

I assume your looking for the real rowsize, therefore the way to find it is

select sum(vsize(column1)+vsize(column2)+..... ) from <table_name>;

Now if you have nullable columns you need to either not include them in the report or use the nvl function on them.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: NGUYEN Philippe (Cetelem) [mailto:philippe.nguyen@cetelem.fr]
Sent: Monday, August 04, 2003 6:54 AM
To: Multiple recipients of list ORACLE-L
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

-- 
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 - 09:19:22 CDT