count of obj

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Fri, 5 Mar 2004 22:54:38 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C0287E72B@uswaumsx14medge.med.ge.com>

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sat Mar 06 2004 - 00:43:22 CST