select count(*) ( from (select owner,segment_name,segment_type,sum(bytes) from dba_extents group by owner,segment_name,segment_type having sum(bytes)>1048576*1024 ) / On 03/05/2004 11:54:38 PM, "Kommareddy, Srinivas (MED, Wissen Infotech)" wrote: > 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 -----------------------------------------------------------------