Do a rolling restart of the storage cells or the cellsrv process.
If results aren't correct, you should log a ticket with Oracle support. It may
be a known issue that they have a fix for already or they can open up a new bug
once they validate what's going on.
Sent from my iPhone
On Oct 27, 2016, at 4:42 AM, Pawel Smolarz <pawel.smolarz@xxxxxxxxxx> wrote:--
Hi,
We have issue with one query. We confirmed that is a problem with
"Smart Scan" feature.
When Offloading is enabled for query we have wrong results but when we
manually disable offloading using:
alter session set cell_offload_processing=false;
alter session set "_serial_direct_read"=always;
then we have correct results.
Is it possible to refresh storage indexes? I mean rebuild as a normal
index.
Storage server version:12.1.2.3.0.160207.3
--
Pozdrawiam / Regards,
Paweł Smolarz
--
//www.freelists.org/webpage/oracle-l