Slow Session Trace Shows Unrelated MDSYS Trigger(SDO_GEOR_BDDL_TRIGGER ,SDO_GEOR_ADDL_TRIGGER)
(Doc ID 2045385.1)
Last updated on MARCH 14, 2019
Applies to:Oracle Spatial and Graph - Version 188.8.131.52 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 "<owner>"."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 dropped object.
A condition needs to added for the triggers to avoid objects in the recyclebin:
NOT IN (select object_name from recyclebin)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document