You can get the table and it's indexes' or lob segments' size by "ORA SIZE" command easily.
ASQL> ora size sh.t_lobtest
OWNER SEGMENT_NAME SEGMENT_TYPE SIZE_MB INIEXT MAXEXT
----- ------------------------- ------------ ------- ------ ------
SH T_LOBTEST TABLE 0.0625 65536
SH SYS_IL0000012006C00001$$ LOBINDEX 0.0625 65536
SH SYS_LOB0000012006C00002$$ LOBSEGMENT 0.0625 65536
SH SYS_IL0000012006C00002$$ LOBINDEX 0.0625 65536
SH SYS_LOB0000012006C00001$$ LOBSEGMENT 0.0625 65536
You can get the tablespace storage usage report by "ORA TSFREE" command.
ASQL> ora tsfree
TABLESPACE FILES SIZE_MB FREE_MB USED_MB MAXFREE PCT_USED PCT_FREE
---------- ----- ------- ------- ------- ------- -------- --------
SYSAUX 1 120 45.13 74.88 40.94 62.4 37.6
UNDOTBS1 1 200 177.94 22.06 168.94 11.03 88.97
USERS01 3 72 68.5 3.5 23 4.86 95.14
USERS 1 106 66.69 39.56 63.19 37.24 62.76
SYSTEM 1 300 57.25 242.75 56.94 80.92 19.08
5 rows returned.
You can get tablespace extent fragmentation information with "ORA FREESPACE" command.
ASQL> ora freespace
TABLESPACE_NAME SIZE_MB EXTENT_COUNT FILES
--------------- ------- ------------ -----
SYSTEM 57 1 1
UNDOTBS1 169 1 1
USERS 63 1 1
3 rows returned.
I love these custom commands, it make my DBA work easier.