Tuesday Jul 01, 2014

Posting Performance Issues Reported After 11.2.0.4 Database Upgrade

Posting is the main General Ledger process that updates the account balances for detail and summary accounts. As the program is submitted multiple times almost every day and the volume of data processed by this concurrent request is sometimes huge, getting a good performance for each run is crucial for having up-to-date balances available for reporting purposes at any moment. 

After upgrading RDBMS to 11.2.0.4, Posting performance issues were reported due to a new optimizer feature introduced for Database. Posting uses a bad execution plan and might get severe performance issues or simply hang at glpubr.concurrency procedure: 

Posting Logfile

Did you upgrade to RDBMS 11.2.0.4 recently? Do you plan to upgrade?

Ensure proper application usage for your users through a proactive patching plan!

This recently updated document provides all the needed details to help avoid a known issue: 

GLPPOS Poor Performance after DB Upgrade to 11.2.0.4.0: Program Stuck on Glpubr.Concurrency (Doc ID 1602141.1)

About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today