Model binding slow post migration to Oracle 19c

[loganfox]

Hi everyone,

I'm in the process of migrating our backend from Oracle 11g to 19c. During testing I noticed that one of our DB calls has slowed down somewhat. On the older 11g schema, the call took around 2 seconds to run and return results, where as the new 19c schema the call takes between 10-15 seconds to finish running. It's a very simple select statement and running the same statement directly in TOAD takes under a second to return 7 records.

After further testing, I've concluded it only happens (or most notably) when model binding is used.

Code: Select all

_db.ExecuteQuery<MY_TABLENAME>("sql statement").ToList();

When making a call using OracleCommand("SQL statement here") the results come in nice and quick. I can't however explain why the change from 11g to 19c would cause model binding to slow down so much. Does anyone have any ideas on how I might improve the performance?

Specs:
c#
.NET 4.52
Devart.Data v5.0.1431.0 (runtime v2.0.50727)
Devart.Data.Linq v4.5.976.0 (runtime v2.0.5027)
Devart.Oracle v9.0.7.0 (runtime v2.0.5027)
Devart.Oracle.Linq v4.5.976.0 (runtime v2.0.5027)

[loganfox]

Reposted question here with more detail: viewtopic.php?f=31&t=56550