Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Slowness in loading portlet with Oracle11g

Highlighted
Cat_2
Regular Collector

Slowness in loading portlet with Oracle11g

We're running PPM 8.03. We recently transitioned from Oracle 10 to Oracle 11 and we are experiencing some slowness. Not dramatic, but enough that some larger portlets are not loading. Has anyone else made the database upgrade and if so were there any setting you needed to adjust to increase transaction speed?

4 REPLIES
hyllplan
Frequent Visitor

Re: Slowness in loading portlet with Oracle11g

Oracle 11.2.0.1?
Cat_2
Regular Collector

Re: Slowness in loading portlet with Oracle11g

Yes. Since you said that I checked the SP3 doc and saw...

 

"Oracle 11g hangs on certain select statements. Quartz-related SQL statements are also blocked, resulting in high CPU consumption.

 

The problem is due to a significant amount of library cache: mutex X waits on database objects, which are queried frequently.

 

On Oracle 11.2.0.1, install patch 9067282. This fix allows the marking of specific objects that are known to exhibit high contention so that the contention can be reduced."

 

I've put in a request to apply the patch.

hyllplan
Frequent Visitor

Re: Slowness in loading portlet with Oracle11g

Let me know how it goes! We have a lot of trouble with 11.2.0.1, we will upgrade to 11.2.0.2 asap.

Regards,

Johan

hyllplan
Frequent Visitor

Re: Slowness in loading portlet with Oracle11g

We  have upgraded to 11.2.0.2 seems like it did the trick. PPM now performs as expected

Johan

//Add this to "OnDomLoad" event