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!

Oracle Database Performance Issue

edited Aug 5, 2014 5:00AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered

Hi All,

I have a problem that the oracle database is too  slow especially when selecting from payroll tables in order to view payroll run for specific month.

I've run "gather Schema Statistics " for ALL and Run "gather table statistics " for pay_run_result_values_v table, it is much t better  now but still slow.

Any suggestions??

Thank you,


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