Performance - EBS (MOSC)

MOSC Banner

Forms performance is slow

edited Apr 28, 2014 10:09AM in Performance - EBS (MOSC) 8 commentsAnswered

Hello Everyone,

There are two application nodes. User login from the first node, and the 2nd node is only for PCP, but this is also Forms tier: <TIER_FORMS oa_var="s_isForms">YES</TIER_FORMS>

The Forms number of process is 27 on the first node. <forms_nprocs oa_var="s_forms_nprocs">27</forms_nprocs>

The Forms number of process is 7 on the second node. <forms_nprocs oa_var="s_forms_nprocs">7</forms_nprocs>

But During end of month (closing period), the performance of Forms is very slow, such as load Forms, query data from Forms.

The number of active users is 4229, is it necessary to increase s_forms_nprocs on 2nd node from 7 to 27?

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center