Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: size in bytes of a table
The user_segments view will give you the allocated size of the table or
index segment. Since a heap table and normal index can share the same
name you might also want to include " and segment_type = 'TABLE' ".
This points out that you may also want to count up the size of the
indexes associated with the table. You can find all the indexes for a
table by looking at all_, user_, or dba_indexes.
You can find all the dictionary views documented in the Oracle version# Reference Manual.
If you want to know the used as opposed to allocated space then multiply dba_tables.blocks times the tablespace block size.
HTH -- Mark D Powell -- Received on Mon Jul 18 2005 - 08:55:51 CDT