Re: ORA-30027: Undo quota violation
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: arpitdba2019@xxxxxxxxx, Oracle-L oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Apr 2020 08:57:07 +0100
Morning Arpit,
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
