Re: ORA-01554: transaction concurrency limit reached reason:no undo segment found with available slot params:0, 0 :
From: Remigiusz Sokołowski <remigiusz.sokolowski_at_gmail.com>
Date: Fri, 29 Jun 2018 14:34:42 +0200
Message-ID: <CACLSTZk=PzmjXdUvxghcgoM6QzdUoOS0WD67F3-SyeP8FViVvg_at_mail.gmail.com>
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
Remigiusz Sokołowski <remigiusz.sokolowski_at_gmail.com>
--
http://www.freelists.org/webpage/oracle-l Received on Fri Jun 29 2018 - 14:34:42 CEST
Date: Fri, 29 Jun 2018 14:34:42 +0200
Message-ID: <CACLSTZk=PzmjXdUvxghcgoM6QzdUoOS0WD67F3-SyeP8FViVvg_at_mail.gmail.com>
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_at_gmail.com>
--
http://www.freelists.org/webpage/oracle-l Received on Fri Jun 29 2018 - 14:34:42 CEST