Re: ORA-30027: Undo quota violation

Hey Norm,

Ok so i could find out a way using DBA_RSRC_PLAN_DIRECTIVES and I see CLOUD_GROUP2_HIGH resource consumer group has undo_pool as 5GB , does this means any statements by a user having CLOUD_GROUP2_HIGH as resource manager group will terminate if they would need undo quota greater than 5G ?

Also is it normal for DDL statements to hit this error ?

Regards,
Arpit

On Thu, 9 Apr 2020 at 14:30, Arpit Aggarwal <arpitdba2019_at_gmail.com> wrote:

> Hey Norm,
>
> I have increased the quota for the user. I see that this user has
> INITIAL_RSRC_CONSUMER_GROUP as "CLOUD_GROUP2_HIGH".
> How can i see the attributes that has been given while creating this
> consumer group , wanted to see if undo_pool has been mentioned or not .
> Is there a way to fetch DDL for a consumer group from get_ddl procedure ?
>
>
> Regards,
> Arpit
>
> On Thu, 9 Apr 2020 at 13:27, Norman Dunbar <oracle_at_dunbar-it.co.uk> wrote:
>
>> 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
>>
>

--
http://www.freelists.org/webpage/oracle-l