Page 1 of 1
Problem with number of Oracle sessions opened
Posted: Mon 05 Aug 2013 09:35
by malea
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.
Re: Problem with number of Oracle sessions opened
Posted: Tue 06 Aug 2013 12:48
by Pinturiccio
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.
Re: Problem with number of Oracle sessions opened
Posted: Tue 06 Aug 2013 13:52
by malea
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.
Re: Problem with number of Oracle sessions opened
Posted: Wed 07 Aug 2013 06:27
by malea
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.
Re: Problem with number of Oracle sessions opened
Posted: Thu 08 Aug 2013 13:04
by Pinturiccio
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.
Re: Problem with number of Oracle sessions opened
Posted: Fri 09 Aug 2013 07:48
by malea
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.
Re: Problem with number of Oracle sessions opened
Posted: Mon 12 Aug 2013 11:02
by malea
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
Re: Problem with number of Oracle sessions opened
Posted: Tue 13 Aug 2013 09:03
by MariiaI
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();
}
Re: Problem with number of Oracle sessions opened
Posted: Sun 18 Aug 2013 11:11
by malea
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
Posted: Mon 19 Aug 2013 06:00
by MariiaI
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.
Re: Problem with number of Oracle sessions opened
Posted: Fri 06 Sep 2013 07:32
by Helen
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 .