Re: ORA-30027: Undo quota violation
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 9 Apr 2020 08:57:07 +0100
Message-ID: <52f816bb-17be-56a6-af38-d34468b8f6c7_at_dunbar-it.co.uk>
Date: Thu, 9 Apr 2020 08:57:07 +0100
Message-ID: <52f816bb-17be-56a6-af38-d34468b8f6c7_at_dunbar-it.co.uk>
On 09/04/2020 08:44, Arpit Aggarwal wrote:
> I have a 11204 database where I am seeing ORA-30027: Undo quota
> violation - failed to get 100 (bytes) , error in application logs.
Are you increasing quote for the user account that is failing? If so, it could be that you are using resource manager and might need to increase the UNDO_POOL limits for the resource plan in use by the user.
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2020 - 09:57:07 CEST