Slow Session Trace Shows Unrelated MDSYS Trigger(SDO_GEOR_BDDL_TRIGGER ,SDO_GEOR_ADDL_TRIGGER)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 and later
Information in this document applies to any platform.
While executing an INSERT into a table the RDBMS needs space and executes
drop table "ETFODIAPP"."BIN$G5Cf3MGgEGPgUxAj9ArXHg==$0" purge
to release enough continuos space to fullfil the INSERT requirement
The DROP triggers SDO_GEOR_ADDL_TRIGGER and SDO_GEOR_BDDL_TRIGGER
which in this case should not be executing as the supposedly dropping table
is already a droped object.
Need to add condition for the triggers to avoid objects in the recyclebin:
NOT IN (select object_name from recyclebin)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms