RE: How can I get information about space within a cluster
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <genegurevich@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Dec 2006 12:56:27 -0500
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
Other related posts:
