IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
Back to discussions
Expand all | Collapse all

Oracle 9i triggers - dbms_alert_info table locks

  • 1.  Oracle 9i triggers - dbms_alert_info table locks

    Posted Mon June 07, 2004 06:09 AM

    Originally posted by: SystemAdmin


    We have Oracle 9i database and want to use triggers, and in our tests the we let the Event Server running but with no events because we used an test schema within the production database.

    The problem is that some days after, the dbms_alert_info table was locked with severall sessions related with the Mercator user assigned to it and it caused that all other applications couln't write on it.

    Stopping the Event Server solved the problem, but we coudn't find any logs about it ...

    Does anyone has a clue ?

    Thanks,
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


Related Content