|
|
|
|
|
|
Re: Why some of my SQL are run slower in Oracle In-memory than it was before? [message #665510 is a reply to message #665507] |
Fri, 08 September 2017 02:02 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:I am going to disable some objects in-memory by NO_INMEMORY my SQLs to see if i get back to normal performance. This is absolutely the wrong approach. You have paid a massive amount (nearly 50% uplift on your licensing cost) for the inmemory option. You need to make it work, not turn it off. For example, perhaps you are not getting Bloom filtered joins or vectored aggregations. Or perhaps there is too much use of indexed access paths.
|
|
|