Forum Stats

  • 3,734,235 Users
  • 2,246,914 Discussions
  • 7,857,193 Comments

Discussions

Performance issue after upgrade to ORDS 21.1

Hi.

We have performance issue after upgrade from 20.4 to 21.1 version. ORDS is only used for APEX applications.

RDBMS Version 18.5, RAC, 2 nodes. APEX version 19.2.

In version 21.1 ORDS executes on every request sql : "SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'APEX_RELEASE' AND TABLE_NAME = 'APEX_RELEASE'"

In our environment, this request takes about 2-3 seconds, so if there are several hundred active users, everything hangs...

We have created SR regarding the performance of a query to the system dictionary, but there is no solution yet.

What recommendations can be in this case?

Tagged:

Best Answer

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,701 Employee
    Accepted Answer

    Recommend you downgrade ORDS to 20.4...that statement isn't the best, it's been corrected for ords 21.2


    Also, your DB is out of support as of end of June (18c) - consider upgrading that to 19c, and your APEX is also old...

Answers

Sign In or Register to comment.