Recently we Upgraded the database from 12.1.0.2.0 to 12.2.0.1.0 version. We are facing the issue after upgradation in Advanced Reporting.
While we execute Adhoc view and Reports the page is loading but not getting the data after some time timeout error occurred (Unable to Acquire conversation lock after 90 seconds)
Our DBA Increased the memory allocation from 4GB to 6GB and changed some DB parameter as well.
First two/three times Adhoc views and report data getting displayed. Next time same issue has happened.
Kindly advice on this..is there any specific DB parameter need to change?