Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

Payroll Worker Process running slow

edited Feb 3, 2016 12:33PM in Payroll and OTL - EBS (MOSC) Question

EBS 12.1.3 RDBMS 11.2.0.3.0

Payroll Worker Process is taking more than 8 hours to complete.This database is running on Exadata server.

Most of the time it is running followign query

SELECT EEV.SCREEN_ENTRY_VALUE

  FROM PAY_INPUT_VALUES_X IV, PAY_ELEMENT_ENTRY_VALUES_F EEV

WHERE     EEV.ELEMENT_ENTRY_ID = :B2

       AND IV.INPUT_VALUE_ID = EEV.INPUT_VALUE_ID

       AND IV.NAME = :B1

Cell Single block physical read is highest wait event for above query.Explain plan is using Indexes.

Any help to tune the program is greatly appreciated.

Thanks in advance.

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