Performance - EBS (MOSC)

MOSC Banner

R12 (12.1.2) with Database 11gR1 - Performance

edited Nov 8, 2010 6:08PM in Performance - EBS (MOSC) 3 commentsAnswered
 I just want to find if any of you have made any database parameter changes which has given improvement...I have seen, with my development and conversion team having lot of performance issues...

During the employee and asset conversion, the jobs running longer using pl/sql tables with API calls.

I have made few cache parameter changes and reduced the runtime half from the previous runs. Just want to get in touch with the community to see, if anyone has come across such issues and find solution.

I have made the following changes...

result_cache_mode='FORCE'
result_cache_max_size=2G  - Total SGA is set to 9G and removed max_memory parameter.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center