Human Capital Management - EBS (MOSC)

MOSC Banner

11i having slow performance

edited May 15, 2012 5:10AM in Human Capital Management - EBS (MOSC) 5 commentsAnswered
 Hi,
Since 2 week we are facing performance issue in our prodction database. 
Our Environment details:
Node 1 : AppsTier
Node 2 : RAC 1
Node 3 : RAC 2
OS     : Sun Solaris 64-bit space version 10
RAM    : 32GB on each node
DB Size: 340GB 

We have CRM running in our production and recently implemented HR & Finance.
We have scheduled Gather Schema Statistics program weekly once


Navigation across the forms is fine. 
If they enter a SR number and press the COMPLETE button which calls procedure from standard tables the form hangs. The issue normally comes during peak time (10:30am to 12:30pm)

Also our redolog size is 100m and can see log switch every 40secs during peak working hours.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center