https://community.hpe.com/t5/operating-system-hp-ux/schema-object-size/m-p/3195056#M792014 Hi,<BR /> <BR />how about:<BR /> <BR />Select owner, tablespace_name, segment_type, count(*), sum(bytes)<BR />from dba_extents<BR />group by owner, tablespace_name, segment_type;<BR /> <BR />good luck,<BR />Thierry. Wed, 18 Feb 2004 04:31:52 GMT Thierry Poels_1 2004-02-18T04:31:52Z https://community.hpe.com/t5/operating-system-hp-ux/schema-object-size/m-p/3195055#M792013 hello:<BR /><BR /> How can I get sum schema object size from oracle internal view .<BR /><BR /> Thank you!!<BR /><BR /> Wed, 18 Feb 2004 04:04:47 GMT https://community.hpe.com/t5/operating-system-hp-ux/schema-object-size/m-p/3195055#M792013 steven chang_1 2004-02-18T04:04:47Z https://community.hpe.com/t5/operating-system-hp-ux/schema-object-size/m-p/3195056#M792014 Hi,<BR /> <BR />how about:<BR /> <BR />Select owner, tablespace_name, segment_type, count(*), sum(bytes)<BR />from dba_extents<BR />group by owner, tablespace_name, segment_type;<BR /> <BR />good luck,<BR />Thierry. Wed, 18 Feb 2004 04:31:52 GMT https://community.hpe.com/t5/operating-system-hp-ux/schema-object-size/m-p/3195056#M792014 Thierry Poels_1 2004-02-18T04:31:52Z