11g autotask - no history!

All posts relating to Oracle database administration.

Moderator: Tim...

11g autotask - no history!

Postby jonnyd » Thu May 09, 2013 9:15 pm

Hi Tim,

Any idea why some automated tasks might not be running?
All seems enabled, task, maintenance window etc but there is no job history in dba_autotask_job_history.

We have found that the autotask to gather optimzer stats has not been done for 2 years in one of our databases!

Any info much appreciated.

jd
jonnyd
Senior Member
 
Posts: 66
Joined: Fri Mar 05, 2010 9:59 am

Re: 11g autotask - no history!

Postby Tim... » Fri May 10, 2013 7:57 am

Hi.

Have you checked that you have JOB_QUEUE_PROCESSES >0 and your STATISTICS_LEVEL >= TYPICAL ?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17931
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g autotask - no history!

Postby jonnyd » Fri May 10, 2013 8:28 am

both affirmative.

Oracle have suggeted to disable and re-enable the autotask with:

exec dbms_auto_task_admin.disable/enable and wait 24 hrs.

Very strange, this DB has had no stats for over 2 years and no entries at all in the dba_autotask_job_history table.

Will keep probing.

Thanks!
jonnyd
Senior Member
 
Posts: 66
Joined: Fri Mar 05, 2010 9:59 am

Re: 11g autotask - no history!

Postby Tim... » Fri May 10, 2013 8:47 am

Hi.

And all the individual tasks are enabled and the windows look right?

http://www.oracle-base.com/articles/11g ... -11gr1.php

Very strange indeed.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17931
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g autotask - no history!

Postby jonnyd » Sat May 11, 2013 11:18 am

Hi Tim,

I have found that my 2 windows, WEEKNIGHT_WINDO and WEEKEND_WINDOW had both ENABLED=FALSE...

Hmm, maybe that is the issue.

I have set them both to ENABLED=TRUE and will have to wait to see if that corrects the issue.

Will keep you posted.

thnx. jd
jonnyd
Senior Member
 
Posts: 66
Joined: Fri Mar 05, 2010 9:59 am

Re: 11g autotask - no history!

Postby Tim... » Sat May 11, 2013 1:32 pm

OK. Let me know how you get on.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17931
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g autotask - no history!

Postby jonnyd » Mon Jun 10, 2013 9:10 pm

managed to fix this by re-creating the schedule window, ie dropping SUNDAY WINDOW and re-creating it.
The auto stats has become stuck in that window. The schedule window was stuck in active status.
jonnyd
Senior Member
 
Posts: 66
Joined: Fri Mar 05, 2010 9:59 am

Re: 11g autotask - no history!

Postby Tim... » Mon Jun 10, 2013 9:18 pm

OK. Good to know.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17931
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 5 guests