Problem with number of Oracle sessions opened

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Problem with number of Oracle sessions opened

Post by malea » Mon 05 Aug 2013 09:35

Hello,

First of all, sorry for my English...

I have installed latest version of dotConnect for Oracle Professional (7.8.287).

Till now I was using version 5.70.

After updating I have noticed that my app has multiplied by 2 the number of oracle sessions opened. Is this normal?
I have compared the number of oracle sessions opened by my app while I'm doing the same tasks, with v570 and with v7.8.

My app is used in a big company by many users simultaneously. And now they reach the limit of oracle sessions defined in the DataBase several times each day, obtaining crashes and errors.

What can I do? What is the difference between version 5.70 and latest version of dotConnect for oracle? Why is it necessary the double of connections to oracle that before?

I hope you can help me.

Thank you.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Problem with number of Oracle sessions opened

Post by Pinturiccio » Tue 06 Aug 2013 12:48

We could not reproduce the issue. Please provide the following information:
1. Your application type (Windows Forms, Web Application etc.);
2. Which technologies do you use in your application:
- Entity Framework
- LinqConnect
- SQL Server Integration Services
- Advanced Queuing Technology
- Or other features.

If possible, create and send us a small test project with the corresponding DDL/DML scripts for reproducing the issue.

malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Re: Problem with number of Oracle sessions opened

Post by malea » Tue 06 Aug 2013 13:52

1. My app is a Windows Forms app. I use .net framework 4.

2. I use crystal reports, infragistics netadvantage for Windows forms and oraclient10g to connect to database.

The only change I have done is to update the version of dotconnect for oracle.
I have tested my app many times with the same result.
Now my app has multiplied by two the number of oracle sessions and processes needed to do the same tasks.

malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Re: Problem with number of Oracle sessions opened

Post by malea » Wed 07 Aug 2013 06:27

On July (02/07/2013), I sent my app to Mariia for another problem.

If you want you can use it for reproducing the issue.

If you don't have it, tell me it and I will send it to you again.

Thank you.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Problem with number of Oracle sessions opened

Post by Pinturiccio » Thu 08 Aug 2013 13:04

malea wrote:On July (02/07/2013), I sent my app to Mariia for another problem.
Yes, we have your project. As MariiaI wrote http://forums.devart.com/viewtopic.php? ... 440#p92984, we cannot start your solution in our environment. Your solution is too big and we cannot revamp it completely. Please locate the error and find which project causes the issue. If it's possible, please create a smaller complete test project for reproducing the issue and send it to us.

malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Re: Problem with number of Oracle sessions opened

Post by malea » Fri 09 Aug 2013 07:48

Pinturiccio wrote:
malea wrote:On July (02/07/2013), I sent my app to Mariia for another problem.
Yes, we have your project. As MariiaI wrote http://forums.devart.com/viewtopic.php? ... 440#p92984, we cannot start your solution in our environment. Your solution is too big and we cannot revamp it completely. Please locate the error and find which project causes the issue. If it's possible, please create a smaller complete test project for reproducing the issue and send it to us.
My app works good without any error or exception. The problem is that after updating the version of your software, it needs the double of sessions and processes of Oracle to do the same tasks that before.
I will try to modify my project and reduce it, but I don't know if I'm going to get success.

malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Re: Problem with number of Oracle sessions opened

Post by malea » Mon 12 Aug 2013 11:02

After a lot of tests, I think that the problem could be in this method:

Code: Select all

public CostesCliente GetCostesCliente(string codCliente)
{
    var costes = new CostesCliente();
    using (var context = new FranceContext())
    {
        using (var com = context.Connection.CreateCommand())
        {
            com.CommandText = "SELECT YPORCENPLA_0 FROM FACILITY" 
                              + "WHERE FCY_0 = '101'";
            context.Connection.Open();
            costes.RemiseException = (decimal)com.ExecuteScalar();
        }
        ...
    }
    return costes;
}
The method is longer, but I think the problem is in this part.
If you want to see the full method, it is in ClientesRepository.cs class, line 83

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Problem with number of Oracle sessions opened

Post by MariiaI » Tue 13 Aug 2013 09:03

We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.
As a temporary workaround, please try closing the connection in this part of your code:

Code: Select all

using (var com = context.Connection.CreateCommand())
        {
            com.CommandText = "SELECT YPORCENPLA_0 FROM FACILITY"
                              + "WHERE FCY_0 = '101'";
            context.Connection.Open();
            costes.RemiseException = (decimal)com.ExecuteScalar();
            context.Connection.Close();
        }

malea
Posts: 33
Joined: Fri 25 Jan 2013 08:25

Re: Problem with number of Oracle sessions opened

Post by malea » Sun 18 Aug 2013 11:11

Thank you for the info.
I will close the connection till you have more info about the issue.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Problem with number of Oracle sessions opened

Post by MariiaI » Mon 19 Aug 2013 06:00

malea wrote:Thank you for the info.
I will close the connection till you have more info about the issue.
The issue has been fixed. The fix will be included in the next build of dotConnect for Oracle. We will inform you when it is available for download.

Helen
Devart Team
Posts: 127
Joined: Wed 07 Sep 2011 11:54

Re: Problem with number of Oracle sessions opened

Post by Helen » Fri 06 Sep 2013 07:32

New version of dotConnect for Oracle 7.9 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).

For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27875 .

Post Reply