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>
Morning Arpit,
On 09/04/2020 08:44, Arpit Aggarwal wrote:
> I have a 11204 database where I am seeing ORA-30027: Undo quota
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,
> violation - failed to get 100 (bytes) , error in application logs.
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-l
Received on Thu Apr 09 2020 - 09:57:07 CEST