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

From: <genegurevich_at_discoverfinancial.com>
Date: Fri, 8 Dec 2006 12:03:22 -0600
Message-ID: <OFF1FB60CD.E9A07E33-ON8625723E.006314BB-8625723E.00632DAF@discoverfinancial.com>

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 Received on Fri Dec 08 2006 - 12:03:22 CST