Campus Solutions - PSFT (MOSC)

MOSC Banner

Question about turning baseline off and on in Oracle 11.2.0.4

edited Sep 13, 2014 5:01AM in Campus Solutions - PSFT (MOSC) 1 commentAnswered

We recently upgraded to Oracle 11.2.0.4 for our Campus Solutions 9.0 database and we have a refund job that is running slower than it normally does after the upgrade. Our DBA is suggesting that we turn off baseline (parameter?) while running the refunds and then turning it back on again and then rebuild some indexes for the tables called by the job.

It seems to me that we should not have to do temporary things like this to our database to make it perform well. Is there something else we can do?

The job normally runs in fifteen minutes, but in the new database with baseline on it runs in 1 hour. If we turn baseline off, it runs in 13 minutes in our QA environment.

Tagged:

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

PSFT Campus Solutions Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center