Database Tuning (MOSC)

MOSC Banner

master table vs log table in 11.1.0.7 database

edited Aug 26, 2013 10:40PM in Database Tuning (MOSC) 2 commentsAnswered ✓
Hi,

database version=11.1.0.7

We have one perfomance issue where it is resolved but just want to know the root cause for this?

issue:application team is runnning the job from java application where it will truncate the table who have two partitions.Table count have 5crore rows.

2 months back same job took just 20 minutes but now after triggering the job it is taking more than 4 hours but still runnig.


-->i have eliminated stats is not the problem and there is no change is database level/OS level/application level.

-->i dont have baseline report where the job ran successfully last 2 months back.

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