Question3Replies161Views Avacado@1 Member since 2011 14 posts Cognizant Technology Solutions Pvt Ltd Posted: 3 years agoLast activity: 3 years 6 months ago Closed Solved Performance issues with Oracle 12c DBWe have recently upgraded the app from 5.4 to Pega 7.2 along with the Oracle 10g to Oracle 12c.But now we observed that all the queries are taking huge time in Oracle 12c when it compared with 10g. Does any one has any idea like is there any special settings has to be made at the DB level/ weblogic level etc.. Any help would be appriciated. System Administration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoBASAVARAJ PEGA replied to Avacado@1Hi SeethaRamaRaju, Can you try dropping all the indexes and re-create again? Is not performed post upgrade Regards, Basavaraj Kadakol Posted: 3 years agoAvacado@1 Cognizant Technology Solutions Pvt Ltd replied to BASAVARAJI think we haven't performed, but we have decided to do this.Let me try and let you know Accepted Solution Posted: 3 years agoAvacado@1 Cognizant Technology Solutions Pvt Ltd replied to Avacado@1Performance is improved by making the below changes and we are still working on to improve further. DB Cache increased to 16GB Additional missing indexes created on 12c Database by DBA. For now please mark this question as resolved.