Cell offloading inconsistency
765115Apr 3 2012 — edited Jun 21 2012I'm not able to get cell offloading to kick in consistently for the SQLs in my system. For the same SQL, I have noticed that sometimes cell offloading happens and sometimes it does not. The SQLs in question do a full table scan on quite a large table (40 million rows) and have some filters on this table. I hope they are a good candidate for offloading.
The DB parameters are set as below and there have been no changes to them -
CELL_OFFLOAD_PROCESSING = TRUE
CELL_OFFLOAD_DECRYPTION = TRUE
CELL_OFFLOAD_PARAMETERS = NULL
CELL_OFFLOAD_COMPACTION = ADAPTIVE
My questions is- Is there a way to get cell offloading to work consistently. As of now, I have been able to achieve by setting serialdirect_read = TRUE, but I don't think this would be recommended.
Please advise.
Edited by: museshad on Apr 3, 2012 1:14 PM