Re: Table sizes
Date: Fri, 10 Sep 1993 19:48:29 GMT
Message-ID: <Sep10.194829.34732_at_yuma.ACNS.ColoState.EDU>
In article <CCsDxq.4v3_at_bfsec.bt.co.uk> dhiggins_at_bfsec.bt.co.uk writes:
>
>Does anyone have a sql script file to list
>the sizes (in k or MB) of tables owned by a user ?
>
>
>
>Thanks in advance
>
> Declan
>---
>
>
>
> Declan Higgins - dhiggins_at_bfsec.bt.co.uk
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "Mihi crede, hoc mihi magis quam tibi nocet"
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
column bytes format 99,999,999
column created format a19
column modified format a19
column type format a6
column name format a18
break on report
compute sum of bytes on report
select a.object_name name,
a.object_type type,
to_char(a.created,'DY MM/DD/YY HH24:MI') created,
to_char(a.modified,'DY MM/DD/YY HH24:MI') modified,
b.bytes
from user_objects a, user_segments b
where a.object_name = b.segment_name and
a.object_type = b.segment_type
order by b.bytes desc
/
|------------------------------------------------------------------------------
------------ ___ ___ |
( I want you ) ---> _/<|>\__/<|>\_ If you ever allow yourself to |
------------ / \ believe that you are the |
\ _ _ / greatest thing to walk on the |
---------------------- \ /o\ /o\ / face of the Earth, remember: to |
Carlo Ciuffoli \ \__________/ crocodile, you're just a lump |
Data Base Applications \ of bipedal protein. |
Office of Budgets \ \/\/\/\/ --------------------------------------|
Colorado State University /\/\/\ e-mail: ciuffoli_at_paris.ir.colostate.edu|
Fort Colins, CO 80525 \____/
-------------------------------------------------------------------------------
Received on Fri Sep 10 1993 - 21:48:29 CEST