RE: how to find max_row_size ?
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Dec 2004 15:20:45 -0600
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
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
