select=20column_name,data_length from=20dba_tables=20a,=20dba_tab_columns=20b where=20a.owner=20=3D=20'OWNERNAME' =20=20and=20a.table_name=20=3D=20'TABLENAME' =20=20and=20a.table_name=20=3D=20b.table_name -----Original=20Message----- From:=20Seema=20Singh=20[mailto:oracledbam@xxxxxxxxxxx] Sent:=20Thursday,=20December=2016,=202004=202:34=20PM To:=20oracle-l@xxxxxxxxxxxxx Subject:=20how=20to=20find=20max_row_size=20? Hi, how=20to=20find=20max_row_size=20of=20table? thanks -- //www.freelists.org/webpage/oracle-l For=20technical=20support=20please=20email=20tech_support@xxxxxxxxxxx=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@xxxxxxxxxxx= . -- //www.freelists.org/webpage/oracle-l