Database Administration (MOSC)

MOSC Banner

after EBS 11i DB upgrade from 9i to 10g R2 10.2.0.5 retropay rollback hangs until killed on OS

edited Dec 12, 2014 10:01AM in Database Administration (MOSC) 2 commentsAnswered

Hi everybody

I have been looping around my self for more than one week now without any solution.

First of all my environment is

OS IBM AIX 6.1

DB was 9i then upgraded to 10.2.0.5 ( another test on 10.2.0.3 with same issue)

EBS 11i 11.5.10.2

after upgrading the database our HR consultant was testing the instance and faced some problems with performance when running payrole request and editing init.ora solved it by adding

_optimizer_cost_based_transformation = off

_optimizer_push_pred_cost_based = false

_gby_hash_aggregation_enabled = FALSE

optimizer_index_cost_adj = 50

optimizer_index_caching = 0

after that rolling back the payroll (retropay) hanged for a long time, terminating the request didn't kill the process so I had to kill it from OS

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