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@xxxxxxxxxxxxxxxxxxxxx < genegurevich@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxx oquest.com> To <genegurevich@xxxxxxxxxxxxxxxxxxxxx 12/08/2006 11:56 >, <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of genegurevich@xxxxxxxxxxxxxxxxxxxxx Sent: Friday, December 08, 2006 11:46 AM To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l
-- Niall Litchfield Oracle DBA http://www.orawin.info