Re: How can I get information about space within a cluster

That's correct, you allocate space to the cluster, not to the individual tables within it. Hence my suggestion that you needed to look at DBA_SEGMENTS since storage is allocated to each segment whether table,index,cluster or whatever else I have forgotten about.

On 12/8/06, genegurevich_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> wrote:
>
> Mark,
>
> Thanks. It does help. Based on what you have said though it sounds like
> the
> most I can see is the space allocated
> to the whole cluster, but I can not break it down by the table. Am I
> correct here?
>
> thank you
>
> Gene Gurevich
>
>
>
>
> "Bobak, Mark"
> <Mark.Bobak_at_il.pr
> oquest.com> To
> <genegurevich_at_discoverfinancial.com
> 12/08/2006 11:56 >, <oracle-l_at_freelists.org>
> AM cc
>
> Subject
> RE: How can I get information about
> space within a cluster
>
>
>
>
>
>
>
>
>
>
> Space is allocated to a cluster, not to tables within the cluster. If
> you query on cluster_name, sum(bytes) where segment_type='CLUSTER',
> you'll see how much space is allocated to each cluster. To see what
> tables are in a given cluster, query on table_name from dba_tables where
> cluster_name = 'your cluster'.
>
> Does that help?
>
> -Mark
>
>
> --
> Mark J. Bobak
> Senior Oracle Architect
> ProQuest Information & Learning
>
> There is nothing so useless as doing efficiently that which shouldn't be
> done at all. -Peter F. Drucker, 1909-2005
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> genegurevich_at_discoverfinancial.com
> Sent: Friday, December 08, 2006 11:46 AM
> To: oracle-l_at_freelists.org
> Subject: How can I get information about space within a cluster
>
> Hi everyone:
>
> I have never dealt with oracle clusters. We have one app that utilizes
> them and I was asked to calculate the space of the tables within a
> cluster (the DB is oracle 10.2) - used and allocated. I have looked
> through the dba_ tables , but couldn't find any data there. Does anyone
> know how to accomplish this task?
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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