Database Software

I recently stumbled upon a post for an undocumented golden gate procedure that I find VERY useful when repairing / simplifying spatial data as a DBA without causing user triggers to fire and do unnecessary work, etc. Anything with foo in the name must be good, right? ;-)

HINT: Oracle please make this a documented feature!

This will disable triggers – just for a session – no system wide changes or trigger mods needed! Yes, fire needs to be set to true - to disable the triggers from firing.

exec sys.dbms_xstream_gg.set_foo_trigger_session_contxt(fire=>true);

Note, you will need execute permissions on sys.dbms_xstream_gg first.

See for more info:

http://www.pythian.com/blog/disabling-triggers-per-session/

Bryan