Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - yusufnar

Pages: [1]
1
Bugs and Issues / Re: EA12 with Oracle repository is very slow
« on: November 24, 2016, 08:09:55 pm »
We came accross the same case. It was because of a bug in Oracle which is addressed in 11g and 12c.

The EA executes many queries that includes ALL_SYNONYMS view. Execution time of the queries are expected to complete in milliseconds but they last more than a second. This small differences makes EA to performance badly in Oracle.

The affected Oracle versions are: 11.2.0.1, 11.2.0.2, 11.2.0.3, 11.2.0.4, 12c release1

The problem was gone after applying the PSU.

Details are on MOS notes:  9371529.8 and 22113854.8

The Oracle software we use is version 12.1.0.2 and we applied the PSU 12.1.0.2.161018

It is very possible for any 11g,12c Oracle customers run into this bug.

Yusuf,

Pages: [1]