Tech 15 - Monday 7th Dec: 11:20 – 12:05 I’ve arranged a panel session on the Cost Based Optimizer for UKOUG Tech 2015, with Maria Colgan, Nigel Bayliss, and Chris An...
Acum 3 ore
You've got to have a dream. When you lose your dreams, you die.
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.2 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
The fix for 16921832 is first included in
Interim patches may be available for earlier versions - click here to check.
This bug is only relevant when using Real Application Clusters (RAC) and Parallel Query (PQO)Very high "ksim generic wait event" may be seen when using parallel query in a RAC environment with auto DOP. Also OCSSD may use high CPU. Rediscovery Notes If the system is RAC AND parallel query is used with automatic degree of parallelism AND many sessions are seen to wait for "ksim generic wait event" then this bug may be suspected. AND OCSSD keeps reporting 'clssgmGroupState: requested group state of unknown group' If an interim patch for 16554552 has been installed then an ORA-7445 [kjuinc] might be seen with kxfpRefreshInst on the stack. This fix should be used in place of that fix. Workaround Setting parallel_force_local=true can help avoid this issue.