Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Determining the disk space used by a schema.
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.orgReceived on Thu Jul 13 2006 - 18:25:52 CDT
![]() |
![]() |