RE: how to find max_row

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 16 Dec 2004 15:20:45 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C916B@irv2kexch01>

1 select column_name,data_length
2 from dba_tables a, dba_tab_columns b

  3  where a.owner = 'SAPR3'
  4    and a.table_name = 'CROSS'
  5    and a.table_name = b.table_name

6 union
7 select ' <----MAX_ROW_SIZE----> ', sum(data_length) 8 from dba_tables a, dba_tab_columns b

  9  where a.owner = 'SAPR3'
 10    and a.table_name = 'CROSS'
 11    and a.table_name = b.table_name

12* order by 2
SQL> /

COLUMN_NAME                    DATA_LENGTH


------------------------------ -----------

STATE                                    1
TYPE                                     1
NAME                                    30
INCLUDE                                 40
PROG                                    40
 <----MAX_ROW_SIZE---->                112

6 rows selected.

SQL>
-----Original Message-----

From: Seema Singh [ mailto:oracledbam_at_hotmail.com] Sent: Thursday, December 16, 2004 2:34 PM To: oracle-l_at_freelists.org
Subject: how to find max_row_size ?

Hi,
how to find max_row_size of table?
thanks

--

http://www.freelists.org/webpage/oracle-l

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 16 2004 - 15:23:05 CST

RE: how to find max_row_size ?