I have search high and wide, but most result I get was tablespace percent used (which you can also get via Enterprise Manager).
Now I want to get the result like shown below, while I can get the tables by getting those with 'VALUES_' I'm not quite so sure when it come to size and usage percentage. I understand datafile (.dbf) or tablespace, since there is a lot of examples to learn from the web, but not so much here. Tables here are from dba objects, but should I use dba_segment instead? Thanks.
| TABLE NAME | SIZE(MB) | USAGE(%) |
| VALUES_ENVF | 1539 | 1 |
| VALUES_ENVF_S | 0.063 | 0 |
| VALUES_F | 81880 | 58 |
| VALUES_F2 | 0.063 | 0 |
| VALUES_IMG | 0.25 | 0 |
| VALUES_S | 0.563 | 0 |
| VALUES_SHIP | 15675 | 11 |
| VALUES_SHIP_S | 841 | 1 |