Hi All, The following query is taking long time even to return the first row on a prod box. The configuration of the box is: ( Solaris 2.8), 500 G RAM, 64 CPU (each 1.2 G), oracle 9i: select segment_name, sum(bytes) from dba_segments group by segment_name having sum(bytes)>1048576*1024 ; Even after 7 mins of submitting the above query, I did not get any result. Its still there... Could someone provide any hints/tips on this. Srinivas -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jay Sent: Saturday, March 06, 2004 11:47 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: count of obj 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