Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DEFAULT_MAINTENANCE_PLAN

User_L0DH7Feb 25 2016 — edited Feb 25 2016

Hello, guys.

I have been analyzed my alert.log and I saw this:

Wed Feb 24 22:00:00 2016

Setting Resource Manager plan SCHEDULER[0x3005]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Wed Feb 24 22:00:00 2016

Starting background process VKRM

Wed Feb 24 22:00:00 2016

VKRM started with pid=49, OS id=4055

Wed Feb 24 22:00:08 2016

ALTER SYSTEM ARCHIVE LOG

But, I think is very strange because I disabled this feature, because I had some problem with it and my Oracle Version (11.2.0.1.0 - bug)

I done this,

BEGIN

  DBMS_AUTO_TASK_ADMIN.disable(

    client_name => 'sql tuning advisor',

    operation   => NULL,

    window_name => NULL);

END;

/

and after that:

SET lines 200 pages 100

col DESCRIPTION FOR a100

col parameter_value FOR a15

SELECT parameter_name,parameter_value,is_default,description

FROM DBA_ADVISOR_PARAMETERS

WHERE task_name='SYS_AUTO_SQL_TUNING_TASK'

ORDER BY parameter_name;

no rows selected

So, how it's possible (executed) if I disabled this feature?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2016
Added on Feb 25 2016
6 comments
3,821 views