Issue Description:
-------------------------
In our environment query was taking random time from 3s to 50s.
After further research, we have found that query parsing was taking a long time due to parsing.
Due to bad application coding query has to hard parse most of the time.
Resolution:
---------------------
The issue was related to parsing bug and below are the workaround.
alter system set "_fix_control"='13836796:OFF' scope=both sid='*';
alter system set "_optimizer_cost_based_transformation"=off scope=both sid='*';-------------------------
In our environment query was taking random time from 3s to 50s.
After further research, we have found that query parsing was taking a long time due to parsing.
Due to bad application coding query has to hard parse most of the time.
Resolution:
---------------------
The issue was related to parsing bug and below are the workaround.
alter system set "_fix_control"='13836796:OFF' scope=both sid='*';
Note: You should avoid setting hidden parameters without oracle consultation
