Hi,
Previously I checked only when cell_offload_processing=false to confirm
that problem is with this feature.
Now I run with:
alter session set cell_offload_processing=true;
alter session set "_kcfis_storageidx_disabled"= TRUE;
and still we have wrong results , so problem is not with storage
indexes.
Thanks!
Pozdrawiam / Regards,
Paweł
On Thu, 27 Oct 2016 14:29:40 +0200
Ahmed Aangour <ahmed.aangour@xxxxxxxxx> wrote:
Hi--
Are you sure the problem is due to storage indexes?
To be sure of that you should enable offloading and disable only
storage index by setting the hidden parameter
_kcfis_storageidx_disabled to TRUE
Le 27 oct. 2016 12:58, "Pawel Smolarz" <pawel.smolarz@xxxxxxxxxx> a
écrit :
Ticket is already created I'll let you know what is a solution for
that but maybe someone know smart way to refresh indexes on storage
server
Pozdrawiam / Regards,
Paweł
On Thu, 27 Oct 2016 06:19:20 -0400
Thomas Roach <troach@xxxxxxxxx> wrote:
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
//www.freelists.org/webpage/oracle-l