Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Huge performance degradation when upgrading to efcore 3.1beta or efcore 2.19.80 when connecting to o

Kenny WangJul 19 2020 — edited Aug 10 2020

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()

This post has been answered by Alex Keh-Oracle on Aug 7 2020
Jump to Answer

Comments

Andris Perkons-Oracle

Are you sure you are talking about SQLcl? On the oracle website, I see version 18.3, not 10.3.

Andris

sect55

My typing error. It is 18.3 not 10.3. I corrected it.

Andris Perkons-Oracle

How large is your downloaded file? Does it match the size (21120590 bytes) and the md5 sum (7550bdbc481c4603b41096d95fa89e3f)?

sect55

It says 5K

cl size.jpg

Glen Conway

Just downloaded the sqlcl-18.3.0.259.2029.zip. For me it is:

Capture.JPG

Try again?

sect55

I just tried again in Windows and I am getting the same error. I never had this problem before. It is only 5KB and has not files in it. I cannot extract it. It says the folder is empty.

Andris Perkons-Oracle

Try downloading from another system and/or from another location. It looks like something is preventing you to download files from the internet.

1 - 7

Post Details

Added on Jul 19 2020
11 comments
2,026 views