View Single Post
  #4  
Old 7th August 2019, 08:29
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 592
Juergen is on a distinguished road
Baan: IVc4, ERPLN - DB: Oracle - OS: Linux, Windows
Hello Jasper,

when moving to Oracle 12.2 (With SLES 12) some month ago we also had terrible performance problems with several sessions, caused by FULL TABLE SCANs coming from the generated Oracle execution plans.

In our case setting parameter optimizer_features_enable='11.2.0.4' in the db_resource did solve most of that problems.

See also KB 1986485 "Performance problems after upgrading Oracle to version 12.2" on Infor Support Portal

Regards,
Juergen

Last edited by Juergen : 7th August 2019 at 08:45.
Reply With Quote