SQL Performance (MOSC)

MOSC Banner

Check using hints ot not

edited Jul 19, 2013 4:18AM in SQL Performance (MOSC) 8 commentsAnswered
Hi,

I used this trigger to disable all hints in my application queries.

How can I check that all hints are ignored and that trigger works well?

create or replace trigger ignore_hints_on_logon
after logon on database
begin
execute immediate 'alter session set "_optimizer_ignore_hints"= true';
end;
/

NB: Trigger is INVALID at the end.  WHY?

Best regards.

GD.

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