Re: partition table help

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Tue, 2 Aug 2005 10:01:57 -0700 (PDT)
Message-ID: <20050802170157.3929.qmail@web52810.mail.yahoo.com>

Have you tried 'dba_segments' ? There is a partition_name column, which you can use to group by.

select segment_name, partition_name, sum(bytes) from dba_segments
where segment_name = <your table name>
group by segment_name, partition_name

I am not sure how it would treat CLOB/BLOB.

Thanks,
Deepak

Joe Smith <joe_dba_at_hotmail.com> wrote:

> How do I determine the space used by a partitioned
> table? The traditional
> tablespace scripts (i.e. dba_tablespaces,
> dba_data_files, dba_free_space,
> ...) don't seem to be reporting accurately.
>
> I have one partitioned table that contains CLOB and
> BLOB with "storage in
> row" defined. There is only 13 columns in the
> table. The table is range
> partitioned into 16 partitions. Each partition is
> contained within its own
> tablespace.
>
> Every time I run a query against the table it says
> it is 90% full. In one
> instance I have 7 records in the table and in
> another instance I have 165
> records in the table. Both are relatively new
> instances for testing.
>
> I have looked on metalink and I can see is a FAQ on
> partitioned tables for 8
> and 8i. Is there a site with more information on
> partitioned tables and how
> to determine space used?
>
> thanks.
>
>

> Don’t just search. Find. Check out the new MSN
> Search!
>

http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 02 2005 - 12:46:02 CDT