User got a timeout error when trying to delete documents using either Director or eBweb.
The documents being deleted have file(s) associated with them. Database logging indicated that a query on the M3_OBJECT_REPOSITORY table was taking a long time. Then it was found out that statistic wasn’t running on the database.
The DBA ran the following and then the issue was fixed:
exec dbms_stats.gather_database_stats(cascade => TRUE);