Is there any difference between overhead using literal sql in 11g comparing to 10g?
Hi,
I have a customer who is facing for some days ORA-4031 which leads instance hang on several Production DBs 11.2.0.3.
In the past the customer has upgraded more than 100 Prod DB from 10.2.0.4 to 11.2.0.3 with no other changes but this issue never happened in 10g DB version.
I have a customer who is facing for some days ORA-4031 which leads instance hang on several Production DBs 11.2.0.3.
In the past the customer has upgraded more than 100 Prod DB from 10.2.0.4 to 11.2.0.3 with no other changes but this issue never happened in 10g DB version.
Support and notes found on MOS suggest to use Note:430473.1, ORA-4031 Common Analysis/Diagnostic
Scripts and change the initialization parameter
CURSOR_SHARING=EXACT (default) to FORCE as there were a lot of
statements that were using literals instead of bind variables.
It seems to be a common problem when upgrading from 10g to 11g that ORA-4031 are reported when CURSOR_SHARING are set to EXACT but the customer needs to know if there is any difference between overhead using literal sql in 11g comparing to 10g to avoid the other 100 Production DB to have this issue.
0