Re: Determining the disk space used by a schema.

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 13 Jul 2006 23:06:23 +0100
Message-ID: <5sgdb25jf9bn90k0o02lqjdg43rblu624o@4ax.com>

On 13 Jul 2006 15:02:10 -0700, 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.

Sum USER_SEGMENTS.BYTES.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Jul 13 2006 - 17:06:23 CDT