Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to find max_row_size ?

RE: how to find max_row_size ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US