RE: how to find max_row_size ?

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 16 Dec 2004 15:14:22 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C916A@irv2kexch01>

=20=201=20=20select=20column_name,data_length
=20=202=20=20from=20dba_tables=20a,=20dba_tab_columns=20b
=20=203=20=20where=20a.owner=20=3D=20'SAPR3'
=20=204=20=20=20=20and=20a.table_name=20=3D=20'CROSS'
=20=205=20=20=20=20and=20a.table_name=20=3D=20b.table_name
=20=206=20=20union
=20=207=20=20select=20'=20<----MAX_ROW_SIZE---->=20',=20sum(data_length)
=20=208=20=20from=20dba_tables=20a,=20dba_tab_columns=20b
=20=209=20=20where=20a.owner=20=3D=20'SAPR3'
=2010=20=20=20=20and=20a.table_name=20=3D=20'CROSS'
=2011=20=20=20=20and=20a.table_name=20=3D=20b.table_name
=2012*=20order=20by=202

SQL>=20/ COLUMN_NAME=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20DAT= A_LENGTH

------------------------------=20-----------

STATE=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=201
TYPE=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=201
NAME=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=2030

INCLUDE=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=2040

PROG=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=2040
=20<----MAX_ROW_SIZE---->=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=201=
12

6=20rows=20selected.

SQL>
-----Original=20Message-----
From:=20Seema=20Singh=20[mailto:oracledbam_at_hotmail.com] Sent:=20Thursday,=20December=2016,=202004=202:34=20PM To:=20oracle-l_at_freelists.org
Subject:=20how=20to=20find=20max_row_size=20?

Hi,
how=20to=20find=20max_row_size=20of=20table? thanks

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

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=


=20you=20can

call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
ender=20immediately=20and=20delete=20the=20material.=20
____________________________________________________________________
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=
.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 16 2004 - 15:15:52 CST