AW: Simple DBA Type Question

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Mon, 21 Aug 2000 16:21:57 +0200
Message-Id: <10596.115092@fatcity.com>

The sum size of datafiles:
select sum(bytes) from v$datafile;
The size of all segments:
select sum(bytes) from dba_segments;
The size of all tables:
select sum(bytes) from dba_segments where segment_type=3D'TABLE'; The size of all tables of one user:
select sum(bytes) from dba_segments where segment_type=3D'TABLE' and = owner =3D'
..... ';
And so on. Everything under user with DBA privileges (system,sys.... = ).

Ivo Libal

> -----Urspr=FCngliche Nachricht-----
> Von: Peter Hazelton [SMTP:peterhazelton_at_hotmail.com]
> Gesendet am: Montag, 21. August 2000 16:45
> An: Multiple recipients of list ORACLE-L
> Betreff: Simple DBA Type Question

>=20

> Hi guys

>=20
> Real quick question here! Using SQL plus, how can I determine the =
physical
>=20
> size of my database? If that cannot be done, is there a way to see =
the
> size=20
> of individual tables?

>=20

> Thanks a lot

>=20

> Peter
> =

________________________________________________________________________=

> Get Your Private, Free E-mail from MSN Hotmail at =
http://www.hotmail.com

>=20

> --=20
> Author: Peter Hazelton
> INET: peterhazelton_at_hotmail.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Aug 21 2000 - 09:21:57 CDT