Problem with number of Oracle sessions opened
Problem with number of Oracle sessions opened
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with number of Oracle sessions opened
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.
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.
Re: Problem with number of Oracle sessions opened
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.
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.
Re: Problem with number of Oracle sessions opened
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with number of Oracle sessions opened
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 wrote:On July (02/07/2013), I sent my app to Mariia for another problem.
Re: Problem with number of Oracle sessions opened
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.Pinturiccio wrote: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 wrote:On July (02/07/2013), I sent my app to Mariia for another problem.
I will try to modify my project and reduce it, but I don't know if I'm going to get success.
Re: Problem with number of Oracle sessions opened
After a lot of tests, I think that the problem could be in this method:
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
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;
}
If you want to see the full method, it is in ClientesRepository.cs class, line 83
Re: Problem with number of Oracle sessions opened
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:
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();
}
Re: Problem with number of Oracle sessions opened
Thank you for the info.
I will close the connection till you have more info about the issue.
I will close the connection till you have more info about the issue.
Re: Problem with number of Oracle sessions opened
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.malea wrote:Thank you for the info.
I will close the connection till you have more info about the issue.
Re: Problem with number of Oracle sessions opened
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 .
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 .