Hi all, I have a table that has about 8 million rows and I'd like to
be able to find the space used by the table.
Is there a quick and easy way of doing that?
How do I also calculate space used by all the indexes of the table?

TIA,
Sashi

"Sashi" <smalladi (AT) gmail (DOT) com> a écrit dans le message de news: 4698cdc6-02cf-4ffa-a732-b062dea36ed1...oglegroups.com...
dba_segments

Regards
Michel

On Oct 8, 6:59*am, Sashi <small... (AT) gmail (DOT) com> wrote:
OEM or EM are the easiest, if you have them running.

For EM go to administration, tables, put in the table and table name
to get some information. For space information, tablespaces, pick
your tablespace, show tablespace contents (shows size and extents),
expand extent map, click on a segment, hover over it to see table.
There may be other ways, too. Of course, this is all just a display
of what Michel said, but I've found it useful. It certainly helps to
understand the tables or views underneath.

jg
--
@home.com is bogus.
Germany has more Muslims than Lebanon.