RE: how to find max_row_size ?

  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@xxxxxxxxxxx]
Sent: Thursday, December 16, 2004 2:34 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx 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@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: