Re: Size of data

Allocated or really in use.
Allocated:
select sum(bytes)/1048576 -- 1M
from user_segments
where segment_name = '<your table name>' /
Occupied
You'll need to analyze <table_name> compute statistics and select * from user_tables where table_name = '<your table name>'

Hth,

Sybrand Bakker, Oracle DBA

AM <a.metzger_at_anti-spam.nmg.fr> wrote in message news:38E83DEB.4FAE81D7_at_anti-spam.nmg.fr...
>
> Hi,
>
> I have one table with a lot of data. How can I know the all size
> occupied by my data ?
>
> Regards,
> --
> Please answer to : a.metzger_at_nmg.fr
>
>
Received on Mon Apr 03 2000 - 01:52:26 CDT