Database Tuning (MOSC)

MOSC Banner

Database Trigger

in Database Tuning (MOSC) 20 commentsAnswered ✓

Hello All,

I am trying to create a log on trigger based on module. This is a band aid fix till we can find the performance issue with EF Scaffolding.

Oracle 19.25 cdb/pdb

This works but doesnt satisfy the need for other users
CREATE OR REPLACE TRIGGER OPTIMIZER_FEATURES_TRIGGER
AFTER LOGON
ON DATABASE
BEGIN
/*
This trigger was put in place to assist with EF Core dynamic sql
*/
IF USER IN ('TEST_USER')
THEN
EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''11.2.0.4''';
END IF;
END;
/

SHOW ERRORS;

I need something like belwo
CREATE OR REPLACE TRIGGER OPTIMIZER_FEATURES_TRIGGER_EF_EXE

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