Database Administration (MOSC)

MOSC Banner

caught Ora-4092 after ORA-00018 & ORA-01581

edited Nov 9, 2010 5:59PM in Database Administration (MOSC) 4 commentsAnswered
 HI All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center