Re: ORA-30027: Undo quota violation

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