| cluster table size [message #127956] |
Thu, 14 July 2005 06:26  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
I have created a cluster and added two tables in it. Now i want to see the no. of bytes occupied by those tables, which are added to the cluster.
Which view do i use ?
I m trying to find out in dba_segments view but those table's entries are not thr in dba_segments view but i m able to see those tables in dba_tables view.
Can anyone help me to come out of this problem.
SQL> select table_name,owner
2 from dba_tables
3 where cluster_name='ORDER_ENTERIES'
4 /
TABLE_NAME OWNER
------------------------------ -------------
C_ORDERS SYS
C_ITEMS SYS
C1_ORDERS SYS
C1_ITEMS SYS
SQL> select bytes from dba_segments
2 where segment_name in ('C_ORDERS','C_ITEMS');
no rows selected
Thanks in advance.
Tarun
|
|
|
|
| Re: cluster table size [message #127976 is a reply to message #127956] |
Thu, 14 July 2005 07:58  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
What happens if you look in dba_segments with the segment_name being equal to your cluster name, as opposed to the table names?
MYDBA@ORCL > select distinct segment_type from dba_segments;
SEGMENT_TYPE
------------------
CLUSTER
INDEX
INDEX PARTITION
LOB PARTITION
LOBINDEX
LOBSEGMENT
NESTED TABLE
ROLLBACK
TABLE
TABLE PARTITION
TYPE2 UNDO
11 rows selected.
Oh and watch out on 10gR1 and later on calculating sizes using dba_segments. See my post from yesterday titled Segments and Extents for more info.
[Updated on: Thu, 14 July 2005 07:59] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
