SQL> l 1 select count(*) from dba_segments 2 group by segment_name 3* having round(sum(bytes)/1024/1024/1024) >1 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech) Sent: Friday, March 05, 2004 11:55 PM To: oracle-l@xxxxxxxxxxxxx Subject: count of obj Hi All, Can somebody give a simple query to find the count(*) of objects which have size >1 Gig its not this. select segment_name, round(sum(bytes)/1024/1024/1024) from dba_segmnets group by segment_name having round(sum(bytes)/1024/1024/1024) >1; Need just count(*) of objects in the db > 1Gig size Tx and Regards, Srinivas