Product: E-Notebook Enterprise
Bug in Oracle 11g can affect E-Notebook
Oracle 18.104.22.168 runs a daily job called dbms_space.AUTO_SPACE_ADVISOR_JOB.
There is a bug in it that can cause excessive amounts of redo logs to
be generated which can fill up disk space.
For E-Notebook users, this bug can be diagnosed by looking at the longest running SQL (schema names will change with ELN version). If
createtable "EN1102_AUDIT".DBMS_TABCOMP_TEMP_UNCMP tablespace "TA_EN1102_NB" nologgingasselect/*+ FULL("EN1102_AUDIT"."ENA_DOCUMENTS") */ * from "EN1102_AUDIT"."ENA_DOCUMENTS" sampleblock(68.68) mytab
is the top running SQL, the above job is the culprit.
The job can be disabled by:
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);