Re: Schema Size

From: Yong Huang <yong321_at_yahoo.com>
Date: 7 Nov 2002 11:52:47 -0800
Message-ID: <b3cb12d6.0211071152.23de6854@posting.google.com>

ermin_at_dzinic.com (Ermin) wrote in message news:<ad3c6b43.0211060511.1c11cfac_at_posting.google.com>...
> Hi,
> How can I find out the size of the current schema?

Usually this question is asked about the disk space currently used by a specific user. A simple answer is adding up all BYTES from DBA_SEGMENTS where OWNER = 'THATUSER'. But more accurately, you may also add various SIZEs in DBA_OBJECT_SIZE for that user. This may be insignificant but it's good to know it exists.

Yong Huang Received on Thu Nov 07 2002 - 13:52:47 CST