Guna Sagar Challa

• Mar 27th, 2006

 

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

S.Madhu

• Mar 29th, 2006

 

 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

dev

• Oct 11th, 2006

 

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.