Database Tuning (MOSC)

MOSC Banner

deadlock when trigger fired ?

edited Dec 23, 2012 8:17PM in Database Tuning (MOSC) 11 commentsAnswered
Hello,

 I want to test “pending stats” via disabling all hints in my PL/SQL application.

 I have developed this trigger :

 CREATE OR REPLACE TRIGGER LOGON_TRIGGER

AFTER LOGON ON TOTO.SCHEMA

BEGIN

-- To use Pending Stats

EXECUTE IMMEDIATE 'ALTER session SET optimizer_use_pending_statistics=true';

-- To disable hints

EXECUTE IMMEDIATE 'ALTER session set "_optimizer_ignore_hints"=TRUE';

END;

 When application is lunched, deadlock error is encountered: ORA-04020.

 An idea?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center