When users are not using bind variables, we can force Oracle to bind their queries. Is a last resource solution.
PDB01:SQL> GRANT ADMINISTER DATABASE TRIGGER TO atlas_muon_cert;
Grant succeeded.
PDB01:SQL> @connect
Enter value for username: atlas_muon_cert
USER is "ATLAS_MUON_CERT"
PDB01:SQL> CREATE OR REPLACE TRIGGER atlas_muon_cern_logon after logon on DATABASE
2 DECLARE
3 BEGIN
4 execute immediate 'alter session set cursor_sharing=force';
5 END;
6 /
Trigger created.
PDB01:SQL> exit
Topic revision: r3 - 2005-11-29
- unknown