This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,592 Users
  • 2,269,776 Discussions


what's prvt_advisor.delete_expired_tasks

3236389 Member Posts: 48
edited Apr 26, 2018 12:34AM in Database Ideas - Ideas

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.


blessed DBA
3 votes

Active · Last Updated