Re: count of obj

From: Kresimir Fabijanic <kfabijanic_at_optusnet.com.au>
Date: Sat, 06 Mar 2004 16:16:45 +1100
Message-ID: <40495EBD.7020804@optusnet.com.au>

Hi Srinivas

Sorry to be a bit blunt:

select count (*)
from (select segment_name, (sum(bytes)/(1024*1024*1024) )

       from dba_extents  --- or dba_segments
        group by segment_name
        having (sum(bytes)/(1024*1024*1024)) >1

);

That works for me...or am I missing something?

HTH Kind Regards

Kresimir Fabijanic
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
>

---

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:44 CST