In our app we need to listen to about 20 alerters, which lead to a lot of open oracle sessions. I've used reflector to check the code and turns out that OracleAlerter clones the provided connection which causes slow performance on start and lots of sessions.
Oracle documentation says "A session can register interest in an unlimited number of alerts. ". (http://download.oracle.com/docs/cd/B193 ... _alert.htm)
Is there a way to listen to multiple alerts using single session in Devart?
OracleAlerter cloning the connection
The "DBMS_ALERT.WAITANY" command is executed on the cloned connection until the event is risen. We use the cloned connection in order not to block the main connection object.
As a workaround, we recommend you to specify several alerters names in the AlertName property of the OracleAlerter instance: http://www.devart.com/dotconnect/oracle ... erter.html .
As a workaround, we recommend you to specify several alerters names in the AlertName property of the OracleAlerter instance: http://www.devart.com/dotconnect/oracle ... erter.html .
-
- Posts: 5
- Joined: Thu 19 May 2011 14:45