Re: Storage index - EXADATA

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_at_nordea.com> 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_at_gmail.com> 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_at_nordea.com> 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
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l