WARNING: This web is not used anymore. Please use PDBService.CursorSharing instead!
 
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
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2005-11-29 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback