RE: Schema Sizing

From: McGlaughlin,Stewart <mcglaughlin_at_attws.com>
Date: Tue, 11 Jul 2000 12:40:28 -0400
Message-Id: <10555.111685@fatcity.com>

Stuart,

How about this...
(off the top of my head)

select owner,segment_type,sum(bytes/1024/1024/1024) GBYTES from dba_segments
where owner not in ('SYS','SYSTEM')
group by owner,segment_type;

HTH,
StEWart

---

Stewart McGlaughlin
Oracle DBA
On-site at AT&T Wireless Services
Oracle Links @ http://www.stewartmc.com/oracle stewartm_at_iname.com
(336) 286-1744

> -----Original Message-----
> From: Stuart Houlston [SMTP:Stuart.Houlston_at_bmw.co.uk]
> Sent: Tuesday, July 11, 2000 6:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Schema Sizing
>
> I know I have seen a script somewhere that will give comparisons of the
> size
> of all the objects in each schema's in your database.
>
> Something like
>
> Schema A
> Tables 20GB
> Indexes 15GB
>
> Schema B
> Tables 5GB
> Indexes 7GB
>
>
> etc
>
> Does anybody have such armoury in their war chest... it would be much
> appreciated.
>
>
> Stuart
>
>
> --
> Author: Stuart Houlston
> INET: Stuart.Houlston_at_bmw.co.uk
>
> 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 Tue Jul 11 2000 - 11:40:28 CDT