 |
|
| Computers Forum Index » Computer - Databases - Oracle (Misc) » Storage used by a table... |
|
Page 1 of 1 |
|
| Author |
Message |
| Sashi... |
 Posted: Thu Oct 08, 2009 1:59 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| joel garry... |
| Posted: Thu Oct 08, 2009 5:11 pm |
|
|
|
Guest
|
On Oct 8, 6:59 am, Sashi <small... at (no spam) gmail.com> wrote:
Quote: 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
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
--
at (no spam) home.com is bogus.
Germany has more Muslims than Lebanon. |
|
|
| Back to top |
|
|
|
| Michel Cadot... |
| Posted: Thu Oct 08, 2009 7:04 pm |
|
|
|
Guest
|
"Sashi" <smalladi at (no spam) gmail.com> a écrit dans le message de news: 4698cdc6-02cf-4ffa-a732-b062dea36ed1 at (no spam) s6g2000vbp.googlegroups.com...
| 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
dba_segments
Regards
Michel |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Dec 01, 2009 6:06 am
|
|