Who came up with 1024/1024/1024? I'll gladly help you with queries, but please don't optimize math as I know it. On 03/06/2004 01:16:57 AM, Jay wrote: > 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 > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------