Toad World® Forums

Compression Analysis Results in SQL0952N


#1

I have a subset of tables in my database where the compression analysis tool is failing with an SQL0952N. I’ve searched other threads and they suggested increasing the Connection timeout value in Tools->Options->Database->Timeouts. I have increased the value to 360 and still get the failure. I am including the information I have seen requested in other posts. If anyone has resolved this issue, please let me know.

Number of rows in the table: 24,311,559.

Select * from table(sysproc.admin_get_tab_info(‘PSADDS’,‘RAC_O_CR_REQ_DEC_EVALUATOR_HSTRY’)) as T1

TABSCHEMA TABNAME TABTYPE DBPARTITIONNUM DATA_PARTITION_ID AVAILABLE DATA_OBJECT_L_SIZE DATA_OBJECT_P_SIZE INDEX_OBJECT_L_SIZE INDEX_OBJECT_P_SIZE LONG_OBJECT_L_SIZE LONG_OBJECT_P_SIZE LOB_OBJECT_L_SIZE LOB_OBJECT_P_SIZE XML_OBJECT_L_SIZE XML_OBJECT_P_SIZE INDEX_TYPE REORG_PENDING INPLACE_REORG_STATUS LOAD_STATUS READ_ACCESS_ONLY NO_LOAD_RESTART NUM_REORG_REC_ALTERS INDEXES_REQUIRE_REBUILD LARGE_RIDS LARGE_SLOTS DICTIONARY_SIZE


PSADDS RAC_O_CR_REQ_DEC_EVALUATOR_HSTRY T 0 0 Y 25364480 25364480 1651712 1651712 0 0 0 0 0 0 2 N - - N N 0 N Y Y 0

1 record(s) selected.

Select * from table(sysproc.admin_get_tab_compress_info(‘PSADDS’,‘RAC_O_CR_REQ_DEC_EVALUATOR_HSTRY’,‘REPORT’)) as T1

TABSCHEMA TABNAME DBPARTITIONNUM DATA_PARTITION_ID COMPRESS_ATTR DICT_BUILDER DICT_BUILD_TIMESTAMP COMPRESS_DICT_SIZE EXPAND_DICT_SIZE ROWS_SAMPLED PAGES_SAVED_PERCENT BYTES_SAVED_PERCENT AVG_COMPRESS_REC_LENGTH


PSADDS RAC_O_CR_REQ_DEC_EVALUATOR_HSTRY 0 0 N NOT BUILT - 0 0 0 0 0 0

1 record(s) selected.