we have applications use efcore connecting to oracle exadata 11g. It's been working well before 2.19.80. when i upgrade efcore for oracle to the latest version (2.19.80) or to beta version 3.1, things were getting wrong. Just as the following log shows: it takes nearly 2 minutes to complete one simple query which is unacceptable. before this, it tooks only serveral milliseconds. Can anyone help me?
dbug: Microsoft.EntityFrameworkCore.Database.Command[0]
2020-07-19 16:25:54.008715 ThreadID:9 (SQL) OracleRelationalCommand.ExecuteReaderAsync() : SELECT "p"."PRODUCTID" "ProductId", UPPER(LTRIM(RTRIM("p"."M_ALTERNATENAME"))) "JdeProduct" FROM "MESWIPSMT"."CONTAINER" "c" INNER JOIN "MESWIPSMT"."PRODUCT" "p" ON ("c"."PRODUCTID" = "p"."PRODUCTID") WHERE ("c"."CONTAINERNAME" = :barcode_0) and rownum <= 1
dbug: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[:barcode_0='?' (Size = 2000)], CommandType='Text', CommandTimeout='0']
SELECT "p"."PRODUCTID" "ProductId", UPPER(LTRIM(RTRIM("p"."M_ALTERNATENAME"))) "JdeProduct"
FROM "MESWIPSMT"."CONTAINER" "c"
INNER JOIN "MESWIPSMT"."PRODUCT" "p" ON ("c"."PRODUCTID" = "p"."PRODUCTID")
WHERE ("c"."CONTAINERNAME" = :barcode_0)
and rownum <= 1
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (95,670ms) [Parameters=[:barcode_0='?' (Size = 2000)], CommandType='Text', CommandTimeout='0']
SELECT "p"."PRODUCTID" "ProductId", UPPER(LTRIM(RTRIM("p"."M_ALTERNATENAME"))) "JdeProduct"
FROM "MESWIPSMT"."CONTAINER" "c"
INNER JOIN "MESWIPSMT"."PRODUCT" "p" ON ("c"."PRODUCTID" = "p"."PRODUCTID")
WHERE ("c"."CONTAINERNAME" = :barcode_0)
and rownum <= 1
dbug: Microsoft.EntityFrameworkCore.Database.Command[0]
2020-07-19 16:27:29.682973 ThreadID:9 (EXIT) OracleRelationalCommand.ExecuteReaderAsync()