OracleAlerter cloning the connection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
pavel.tupitsin
Posts: 5
Joined: Thu 19 May 2011 14:45

OracleAlerter cloning the connection

Post by pavel.tupitsin » Thu 19 May 2011 14:53

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 20 May 2011 12:31

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 23 May 2011 11:09

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 .

pavel.tupitsin
Posts: 5
Joined: Thu 19 May 2011 14:45

Post by pavel.tupitsin » Tue 24 May 2011 09:42

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 24 May 2011 10:33

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

pavel.tupitsin
Posts: 5
Joined: Thu 19 May 2011 14:45

Post by pavel.tupitsin » Tue 24 May 2011 14:22

Problem solved, thank you!

Post Reply