SQL> @table_access_paths Owner Name [PROD] Table Name [DOCUMENT_TEXT] ************************************ TABLE ************************************* TABLE_STORAGE STATISTICS NUM_ROWS ROW_LENGTH ----------------------------- ------------------------------ -------- ---------- HEAP 13 hours old 399k 99 DATA_SIZE HWM_SIZE DATA_DENSITY ROW_MIGRATION PCT_FREE PCT_USED FREE_LISTS --------- ---------- ------------ ------------- ---------- ---------- ---------- 42.6M 47.4M 89% nil 10 -> 2 40 -> 96 1 -> 2 BLOCKS BUFFER_POOL POOL_SIZE CACHE PARALLEL_DEGREE FULL_TABLE_SCANS CACHED_NOW -------- ----------- --------- ----- --------------- ---------------- ---------- 12.2k RECYCLE 4000 NO 1 BLOCKS REUSED 357 *********************************** COLUMNS ************************************ COLUMN_NAME NULLS SELECTIVITY ACCESS_PATHS ------------------------------ ------- ----------- ----------------------------- DOC_ID .31% INDEXED LINE 12 rows 2nd index key TEXT full scan *********************************** INDEXES ************************************ INDEX_NAME BLOCKS DENSITY KEY_VALUES ENTRIES TABLE_ORDERING ------------------------------ ------ ------- ---------- -------- -------------- DOCUMENT_TEXT_PK 1.72k 90% 399k 399k 99% COLUMN_NAME STORAGE BUCKETS POPULAR_VALUES NON_POP_DENSITY ------------------------------ ---------- ------- -------------- --------------- DOC_ID COMPRESSED 75 20 .67% LINE NORMAL 75 0 .02% SQL>