Re: count of obj

  • From: Kresimir Fabijanic <kfabijanic@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 06 Mar 2004 16:16:45 +1100

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

  • References:
    • count of obj
      • From: Kommareddy, Srinivas (MED, Wissen Infotech)

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2004