OracleAlerter cloning the connection

OracleAlerter cloning the connection

Postby 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?
pavel.tupitsin
 
Posts: 5
Joined: Thu 19 May 2011 14:45

Postby Shalex » Fri 20 May 2011 12:31

We will investigate the issue and notify you about the results as soon as possible.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby 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.
pavel.tupitsin
 
Posts: 5
Joined: Thu 19 May 2011 14:45

Postby Shalex » Tue 24 May 2011 10:33

Multiple names should be specified in the comma-separated way.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby pavel.tupitsin » Tue 24 May 2011 14:22

Problem solved, thank you!
pavel.tupitsin
 
Posts: 5
Joined: Thu 19 May 2011 14:45


Return to dotConnect for Oracle