Slow Session Trace Shows Unrelated MDSYS Trigger(SDO_GEOR_BDDL_TRIGGER ,SDO_GEOR_ADDL_TRIGGER) (Doc ID 2045385.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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)

Cause

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