...
Code Block | ||||
---|---|---|---|---|
| ||||
USER_NAME TABLESPACE_NAME TABLE_NAME TABLE_OID ALLOC(M) USED(M) EFFICIENCY(%) ------------------------------------------------------------------------------------------------------------------------------------------------------------------- SYS SYS_TBS_MEM_DATA TEST_T2 3323512 0.41 0.38 93.9 SYS USER_MEM_TBS MEM_T1 3321192 0.03 0 0 SYSTEM_ SYS_TBS_MEM_DIC STO_COLUMNS_ 1453416 0.03 0 0 SYSTEM_ SYS_TBS_MEM_DIC STO_DATUMS_ 1469656 0.03 0 0 SYSTEM_ SYS_TBS_MEM_DIC STO_ELLIPSOIDS_ 1471976 0.03 0 0 |
...
Code Block | ||||
---|---|---|---|---|
| ||||
USER_NAME OBJECT_TYPE OBJECT_NAME INDEX_NAME INDEX_TYPE ALLOC ----------------------------------------------------------------------------------------------------------------------------------------------------- SYS TABLE T1 IDX1_T2 b-tree 16 bytes * rowcount SYS TABLE T1 IDX1_T1 b-tree 16 bytes * rowcount 2 rows selected. |
...
Code Block | ||||
---|---|---|---|---|
| ||||
USER_NAME OBJECT_TYPE OBJECT_NAME INDEX_NAME INDEX_TYPE ALLOC(M) ----------------------------------------------------------------------------------------------------------------------------------------------- SYS TABLE T1 IDX1_T2 b-tree 0.76 SYS TABLE T1 IDX1_T1 b-tree 0.76 SYS TABLE T2 IDX2 b-tree 0.31 3 rows selected. |
...
Code Block | ||||
---|---|---|---|---|
| ||||
USER_NAME TABLE_NAME INDEX_NAME INDEX_PARTITIONED SIZE(MB) ---------------------------------------------------------------------------------------------------------- SYS EMPLOYEES __SYS_IDX_ID_143 F 0 SYS EMPLOYEES EMP_IDX1 F 0 SYS FOO __SYS_IDX_ID_171 F 0 SYS GOODS __SYS_IDX_ID_145 F 0 SYS GOODS __SYS_IDX_ID_146 F 0 SYS MEM_T M_IDX01 F 36.5 SYS M_PART_SALES M_IDX_PREFIX T 0 SYS M_PART_SALES IDX_PART_1 T 8.7 SYS M_PART_SALES IDX_PART_2 T 0.7 SYS M_PART_SALES IDX_PART_3 T 0.7 |