Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleExample of output
languagesql
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
titleExample of output
languagesql
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
titleExample of output
languagesql
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
titleExample of output
languagesql
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