Re: Size of object in tablespace

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 16 Aug 2005 02:23:49 GMT
Message-ID: <V6cMe.1824$hF1.1366@newssvr30.news.prodigy.com>

Andreas Sheriff wrote:

> <leo_at_tech-trans.com> wrote in message
> news:1124148678.940359.141070_at_z14g2000cwz.googlegroups.com...
>

>>Hi!
>>
>> How to define the size of object in tablespaces?  For example, the
>>size of user occupies in tablespace.
>>
>>Kai Ming
>>

>
>
> You mean something like:
>
> break on owner
> select owner, tablespace_name, sum(bytes) as bytes
> from dba_segments
> group by owner, tablespace_name;
>
> ?
>

That gets the total size of all segments owned by the owner in a given tablespace, the "for example" part of the OP. The first part, "how do you define...", follows.

For an object, you have to decide which segments you are interested in .. index, LOB, partition, etc. -- all of which can be spread across multiple tablespaces, of course.

Or, for a table or index, you could just use the number of rows as a "logical" measure of size...

-Mark Bole Received on Mon Aug 15 2005 - 21:23:49 CDT