RE: size of a row

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 04 Aug 2003 05:54:23 -0800
Message-ID: <F001.005C8CF5.20030804055423@fatcity.com>

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

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 - 08:54:23 CDT