RE: count of obj

From: Jay <jaysingh1_at_optonline.net>
Date: Sat, 06 Mar 2004 01:16:57 -0500
Message-id: <ECEFIFEIGAOACAHHGDPDMEDDCOAA.jaysingh1@optonline.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
  Sent: Friday, March 05, 2004 11:55 PM
  To: oracle-l_at_freelists.org
  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

---

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 - 01:28:56 CST