what's prvt_advisor.delete_expired_tasks

3236389

Here is using Oracle version 12.2 . And the there is periodically hit mmon process high CPU during 12:00 am ~ 12:30am

Looking into awr and show the top CPU query is the following:

BEGIN prvt_advisor.delete_expired_tasks; END;

What's the package for ? only is 12.2 ? Why it use so much CPU ?

I can't find anything related to prvt_advisor in metalink.

Thanks

Timo Hahn

*** Moderator note (Timo): USer, this is the database idea space. You posted a database question here, not an idea!

As an idea can't be transformed into a question, you have to start a question in the space.

@Chitrasai13-Oracle, can you remove the post from the idea space, please?

***

3236389

thanks. How to move ?

Timo Hahn

thanks. How to move ?

You can't move the idea. You have to start a new discussion.

Timo

blessed DBA

This is not a idea this is a question so you can use other space to use instead idea space