Schema Size

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 6 Nov 2002 13:39:06 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702E385FE@lnewton.leeds.lfs.co.uk>

Two simple ways :

select * from dba_ts_quotas where username = 'WHATEVER';

or

log in to the schema in question and do :

select * from user_ts_quotas;

Both times you get the quota allowed and space actually used in each tablespace in blocks and bytes.

Of course, the space used figure may well not be the actual anmount of data in all the tables/indexes/etc. This is because the INITIAL extent size will be allocated (as will MINEXTENTS) and the space will be marked as allocated, even though you don't yet have any data in the table.

HTH Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: ermin_at_dzinic.com (Ermin) [mailto:ermin_at_dzinic.com] Posted At: Wednesday, November 06, 2002 1:12 PM Posted To: server
Conversation: Schema Size
Subject: Schema Size

Hi,
  How can I find out the size of the current schema?

Thanx in Advance,
Ermin Received on Wed Nov 06 2002 - 07:39:06 CST