Re: ORA-01554: transaction concurrency limit reached reason:no undo segment found with available slot params:0, 0 :

  • From: Remigiusz Sokołowski <remigiusz.sokolowski@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Jun 2018 14:34:42 +0200

Many thanks, Johnatan - with this info I hope, quite well established
what happened and possibly how to prevent this in future - seems
_rollback_segment_count would enforce initially a higher number of
undo segements, thus raising the total possible number of concurrent
transactions

Regards
Remigiusz

p.s. sorry to not cut the answers, but not sure how to enforce gmail
not to attach previous mail in the text


-- 
------------------------------------------------------------------------------------
Remigiusz Sokołowski <remigiusz.sokolowski@xxxxxxxxx>
------------------------------------------------------------------------------------
--
//www.freelists.org/webpage/oracle-l


Other related posts: