Primavera (MOSC)

MOSC Banner

Performance difference between day and night

edited Nov 5, 2013 1:30PM in Primavera (MOSC) 1 commentAnswered
We are in the utility industry and every outage, we do a copy and a baseline of our outage project once daily and once overnight. The problem is that our nightly baseline and copy consistently takes 2-3x as long to complete as the daily baseline and copy. Why is this?

Our DB Index and stats jobs generally run in the early evening, before the overnight baseline and copy. Maybe that's it, but I'd think it would be faster AFTER the index and stats are run, not slower. We monitor database traffic through Oracle EM and this will happen even with no difference in db traffic. We have moved competing jobs to other times. We had the database server guy monitor one night and found nothing unusual. We checked network traffic - nothing unusual.

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