SQL> SELECT ctx_report.index_size('CLOBPRODUCT_CTX') FROM dual;
CTX_REPORT.INDEX_SIZE('PRODUCT_AV_STR_VAL$1')
--------------------------------------------------------------------------------
===========================================================================
             INDEX SIZE FOR TBUDICH_ESL62.PRODUCT_AV_S
TR_VAL$1
=====================================================================
======
INDEX (IOT):                         TBUDICH_ESL62.SYS_IOT_TOP_168059
TABLE NAME:                          TBUDICH_ESL62.DR
$PRODUCT_AV_STR_VAL$1$N
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
                8
BLOCKS USED:
             4
BYTES ALLOCATED:                                         65,536
 (64.00 KB)
BYTES USED:                                              32,768 (3
2.00 KB)
 
INDEX (IOT):                         TBUDICH_ESL62.SYS_IOT_TOP_16805
4
TABLE NAME:                          TBUDICH_ESL62.DR$PRODUCT_AV_STR_VAL$1$K
 
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
                1024
BLOCKS USED:
              962
BYTES ALLOCATED:                                       8,388
,608 (8.00 MB)
BYTES USED:                                            7,880,70
4 (7.52 MB)
 
TABLE:                               TBUDICH_ESL62.DR$PRODUCT_AV_
STR_VAL$1$R
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
    8
BLOCKS USED:
 8
BYTES ALLOCATED:                                         65,536 (64.00 KB)
BYTES USED:
     65,536 (64.00 KB)
 
LOB SEGMENT:                         TBUDICH_ESL62.SYS
_LOB0000168056C00002$$
TABLE NAME:                          TBUDICH_ESL62.DR$P
RODUCT_AV_STR_VAL$1$R
 
CTX_REPORT.INDEX_SIZE('PRODUCT_AV_STR_VAL$1')
--------------------------------------------------------------------------------
LOB COLUMN:                          DATA
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
 1280
BLOCKS USED:                                                          12
80
BYTES ALLOCATED:                                     10,485,760 (10.00 MB)
BYTES USED:
 10,485,760 (10.00 MB)
 
INDEX (LOB):                         TBUDICH_ESL62.SYS
_IL0000168056C00002$$
TABLE NAME:                          TBUDICH_ESL62.DR$PR
ODUCT_AV_STR_VAL$1$R
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
             8
BLOCKS USED:
          8
BYTES ALLOCATED:                                         65,536 (6
4.00 KB)
BYTES USED:                                              65,536 (64.0
0 KB)
 
TABLE:                               TBUDICH_ESL62.DR$PRODUCT_AV_STR_VA
L$1$I
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:                                                     1280
BLOCKS USED:
                  1157
BYTES ALLOCATED:                                     10
,485,760 (10.00 MB)
BYTES USED:                                            9,4
78,144 (9.04 MB)
 
LOB SEGMENT:                         TBUDICH_ESL62.SYS_LOB00
00168051C00006$$
TABLE NAME:                          TBUDICH_ESL62.DR$PRODUCT
_AV_STR_VAL$1$I
LOB COLUMN:                          TOKEN_INFO
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
    8
BLOCKS USED:
 4
BYTES ALLOCATED:                                         65,536 (64.00 KB)
BYTES USED:
 
CTX_REPORT.INDEX_SIZE('PRODUCT_AV_STR_VAL$1')
--------------------------------------------------------------------------------
     32,768 (32.00 KB)
 
INDEX (NORMAL):                      TBUDICH_ESL62.DR$
PRODUCT_AV_STR_VAL$1$X
TABLE NAME:                          TBUDICH_ESL62.DR$P
RODUCT_AV_STR_VAL$1$I
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:
            256
BLOCKS USED:
         177
BYTES ALLOCATED:                                       2,097,152
(2.00 MB)
BYTES USED:                                            1,449,984 (1.
38 MB)
 
INDEX (LOB):                         TBUDICH_ESL62.SYS_IL0000168051C00
006$$
TABLE NAME:                          TBUDICH_ESL62.DR$PRODUCT_AV_STR_VAL
$1$I
TABLESPACE NAME:                     IS_INDX_CTX
BLOCKS ALLOCATED:                                                        8
BLOCKS USED:
                    4
BYTES ALLOCATED:
 65,536 (64.00 KB)
BYTES USED:                                              32
,768 (32.00 KB)
 
TOTALS FOR INDEX TBUDICH_ESL62.PRODUCT_AV_STR_VAL$1
-------------------------------------------------------------
--------------
TOTAL BLOCKS ALLOCATED:
       3880
TOTAL BLOCKS USED:
    3604
TOTAL BYTES ALLOCATED: