No question at this time
DBA Top 10
1 M. Cadot 10000
2 B. Vroman 7600
3 A. Kavsek 3900
4 J. PĂ©ran 1500
5 P. Wisse 1300
6 T. Boles 600
6 D. Johnson 600
8 D. Dave 400
9 S. Spb 300
9 J. Schnackenberg 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48635
Total active users1396
Act. users last 24h0
Act. users last hour0
Registered user hits last week161
Registered user hits last month583
Go up

rollback taking long time oracle
Next thread: time taking to move LOB column
Prev thread: how to find which remote db is accessing source db over db link

Message Score Author Date
Hi Guys, can you please help us ? we have a si...... Rastislav Farar Sep 07, 2021, 13:54
You can't corrupt data killing the process or sh...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Michel Cadot Sep 07, 2021, 14:52
Coming back to my remark about increasing parall...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Michel Cadot Sep 07, 2021, 17:48

Follow up by mail Click here


Subject: rollback taking long time oracle
Author: Rastislav Farar, Slovakia
Date: Sep 07, 2021, 13:54, 12 days ago
Os info: Red Hat Enterprise Linux Server release 7.9
Message: Hi Guys,
can you please help us ?
we have a situation in our production db there is a very large transaction currently rollbacking.
Estimated time of run is 16 plus hours. Is there any possibility to speed up without any data corruption?
we would like to avoid killing the process on OS or DB restart to avoid data corruption


BR
thank you in advance
Rasto
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback taking long time oracle
Author: Michel Cadot, France
Date: Sep 07, 2021, 14:52, 12 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message:
You can't corrupt data killing the process or shutting down the instance, Oracle has strong mechanisms to prevent from this.

Grossly, rollback will take as much time as the transaction ran.

You can speed up recovery (if you choose to shutdown abort the instance) setting "fast_start_parallel_rollback" to "HIGH" and/or increasing "recovery_parallelism" and "parallel_max_servers" (the former is limited by the later).

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback taking long time oracle
Author: Michel Cadot, France
Date: Sep 07, 2021, 17:48, 12 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message:
Coming back to my remark about increasing parallelism, check your IO subsystem and memory can afford it otherwise performances will (drastically) drop down.

Also, obviously, concurrent processes (if there are any) will suffer because of instance recovery load.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here