caught Ora-4092 after ORA-00018 & ORA-01581
I caught a series ORA-04092 after ORA-00018 & ORA-01581, I checked the sql statement, it's only insert to table, but I cannot find any triggers related to the table in DBA_DEPENDENCIES . Add more space to the UNDO resolved ORA-01581 error, but the ORA-4092 persisted.
I also checked all the triggers in the DB, no any commit or rollback or alter/ddl in the trigger.
Are there any internal triggers related to this? After the bounce the instance, the issue recovered , but I don't think this is reasonable.
Do we have some internal triggers for the 10.2.0.3? I searched support but only find some related to MTS or NLS, but I didn't enable any MTS and use the NLS_LANG=AMERICAN_AMERICA.UTF8