Index creation DR$ICX_CAT_ITEMS_CTX_DESC$I .slowness
Hi,
We are executing a plan to rebuild index DR$ICX_CAT_ITEMS_CTX_DESC$I .
1. drop index ICX.ICX_CAT_ITEMS_CTX_DESC FORCE;
2. BEGIN icx_por_ctx_desc.populatedescall('LOADER'); END; - this step is running for 60 hours. Total of 52 hours to populate ICX_CAT_ITEMS_CTX_TLP table and still creating index ICX_CAT_ITEMS_CTX_DESC for 8 hours so far.
Based on our tests on SIT environment, this index should have 10Gb, and until now, only 1Gb was created.
With a simple count, the forecast is that index will be completed in more 48 hours.
Is possible increase the performance without cancel the session?
We are executing a plan to rebuild index DR$ICX_CAT_ITEMS_CTX_DESC$I .
1. drop index ICX.ICX_CAT_ITEMS_CTX_DESC FORCE;
2. BEGIN icx_por_ctx_desc.populatedescall('LOADER'); END; - this step is running for 60 hours. Total of 52 hours to populate ICX_CAT_ITEMS_CTX_TLP table and still creating index ICX_CAT_ITEMS_CTX_DESC for 8 hours so far.
Based on our tests on SIT environment, this index should have 10Gb, and until now, only 1Gb was created.
With a simple count, the forecast is that index will be completed in more 48 hours.
Is possible increase the performance without cancel the session?
0