Devart Forums

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?

We will investigate the issue and notify you about the results as soon as possible.

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 .

Thanks, it should do the job for me, but how do I specify multiple names - should they be comma-separated or something like this? I cannot find this in documentation, all examples are for single name.

Multiple names should be specified in the comma-separated way.

Problem solved, thank you!