Re: Storage index - EXADATA
Date: Thu, 27 Oct 2016 12:57:24 +0200
Message-ID: <20161027125724.288f3e69_at_pawel-laptop>
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,
On Thu, 27 Oct 2016 06:19:20 -0400
> Do a rolling restart of the storage cells or the cellsrv process.
Paweł
Thomas Roach <troach_at_gmail.com> wrote:
>
> 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
Received on Thu Oct 27 2016 - 12:57:24 CEST