Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Determining the disk space used by a schema.

Re: Determining the disk space used by a schema.

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Jul 2006 16:25:52 -0700
Message-ID: <1152833484.772121@bubbleator.drizzle.com>


jayway_at_myrealbox.com wrote:
> I'd like to find out how much disk space is being used by one schema my
> Oracle 10g database. My schema is sharing a tablespace with other
> schemas, so I can't just check the size of the tablespace.
>
> It's probably obvious that I'm not an Oracle expert, but I'll be happy
> to provide any other info you may need.
>
> Thanks for any response, Josh

Alternatively: DBMS_SPACE.OBJECT_SPACE_USAGE.

Documented with a demo in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 13 2006 - 18:25:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US