Hi

Using the below query u can find exactly how much space has been eaten up on the disk by your table:

select bytes from user_segments where segment_name <table name>;

or by using the following query to know actually how many bytes data is stored in the table

select sum(vsize(col1) + vsize(col2) + vsize(col3) +........+ vsize(coln)) from <table_name>;

eg: to find the number of bytes of data in dept table use the following query

SELECT SUM( VSIZE(deptno) + VSIZE(dname) + VSIZE(loc) ) FROM scott.dept;

Guna Sagar Challa

I have created a table in oracle 9i database. How can i know the storage prticulars of a table created in oracle database ?

please give me the answer to my e-mail id.

thank u

Hi

for every table it is giving the same answer like:

SQL> select bytes from user_segments where segment_name 'DEPT';

BYTES
----------
65536

why? I did compress on one table. eventhough it's giving same answer.

Thanks in advance.