can i get a table size with sql?

[mokesql]

hi!
i want ot know if there is a select type in sql or any other statement in sql which get me the size of a table. thnx

kemo

 

[rcurva]

If you have access to DBA_SEGMENTS view, you can issue the following sql:

-- for all tables

SELECT owner, segment_name, SUM(bytes)
FROM DBA_SEGMENTS
WHERE segment_type = 'TABLE'
GROUP BY owner, segment_name

 

[Wes]

You may also want to use user_tables if you have updated statistics on your tables.

 

[rcurva]

A few correction on my sql, no need of grouping the result here:

SELECT owner, segment_name, bytes
FROM DBA_SEGMENTS
WHERE segment_type = 'TABLE';

OR

SELECT owner, segment_name, SUM(bytes)
FROM DBA_EXTENTS
WHERE segment_type = 'TABLE'
GROUP BY owner, segment_name;

You can also use USER_EXTENTS view here.