HCM - JDE1 (MOSC)

MOSC Banner

how to find autoCommit setup for payroll R07200, particularly?

edited Aug 31, 2015 9:07AM in HCM - JDE1 (MOSC) 1 commentAnswered ✓

Hello,

1) I am not in JD Edwards CNC team.

2) Sadly, I am the DBA who is running Oracle databases to support JD Edwards EnterpriseOne application. Thus, a "punchbag" for varieties of slowdowns including Pre-Payroll process R07200 (just learned in the past 2 days), plus.

3) This particular PROCESS (pre-payroll+) updates a bunch of tables, inserts to a bunch of tables, delets from a bunch of tables, and runs very long and repeats, repeats, repeats when multiple users are rush finishing payroll processes.

4) from the database ADDM reports, I often see the following

<quote>

Findings and Recommendations ---------------------------- Finding 1: Commits and Rollbacks Impact is 2.42 active sessions, 72.17% of total activity. --------------------------------------------------------- Waits on event "log file sync" while performing COMMIT and ROLLBACK operations were consuming significant database time.  average redo size of 5510 bytes per transaction.

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