Devart Forums

When i execute this piece of code

OracleConnection oc = new OracleConnection();
oc.ConnectionString = "pooling = false";
oc.Unicode = true;
oc.AutoCommit = true;
oc.Server = "development";
oc.UserId = "user";
oc.Password = "pass";
oc.Open();

OracleCommand o2 = oc.CreateCommand();
o2.CommandType = CommandType.Text;

o2.CommandText = "drop table abc";
try
{ o2.ExecuteNonQuery(); }
catch
{}

o2.CommandText = "create table abc (a varchar2(4000))";
o2.ExecuteNonQuery();

o2.CommandText = "select a from abc where 1 = -1";
for (int i = 0; i < 10000; i++)
{
OracleDataReader or = o2.ExecuteReader();
or.Read();
or.Close();
or.Dispose();
or = null;
}

o2.Dispose();
o2 = null;
oc.Close();
oc.Dispose();
oc = null;

GC.Collect();

Memory usage starts at say around 30mb and gradually rises to around 300mb.

As you can see the query doesnt even return any rows, and the amount of memory used appears to increase/decrease depending on the size of the varchar field that I create.

This does not happen with unicode = false.

Unfortunately, I cannot reproduce memory leak. What tool do you use to count memory usage?

just by watching the memory usage in task manager

Is there anything we can do to help with diagnosing this issue, as its quite important for us as we have a project which relies on unicode support and runs as a windows service and its part of a system that requires 24x7 uptime.

just by watching the memory usage in task manager

I was using task manager too.
What is the versions of OraDirect .NET, Oracle Server and Oracle Client?
Can you send me your compiled test project where I could type my connection information and reproduce the problem?

thanks, I have sent a compiled exe to the support email address.

OK, I will take a look.

Ive upgraded oracle client to 9.2.0.6 and this appears to have solved the issue.

Very well.