OakTable World 2012 slides & videos

I had the privilege of attending some of this year’s OakTable World while attending OOW.  Absolutely fantastic!  If you get the chance to attend OOW in the future, biggie size your trip by spending much of your time at OakTable World and skip some of the OOW sessions.  You won’t regret it.  Check out some of the great slide decks and videos at the link below:

http://dboptimizer.com/oaktable-world/

scheduler unavailable at SYS.DBMS_ISCHED

This is one of those scenarios where you get down in the weeds trying to fix a problem and can’t see the forest for the trees.  Sometimes I see the problem and get right intto the weeds without taking a step back and looking at a simpler view.  This is one of those problems.

Ever seen this when submitting a job (either via OEM or from the command line)?

java.sql.SQLException: ORA-27492: unable to run job “SYS.GATHERSCHEMASTATS_JOEBOB”: scheduler unavailable ORA-06512: at “SYS.DBMS_ISCHED”, line 185 ORA-06512: at “SYS.DBMS_SCHEDULER”, line 486 ORA-06512: at line 2

This was running, or trying to run, against a database I’ve had little interaction with and is more of a backend for a 3rd party appliance.  I dug and dug and was really scratching my head…. opened an SR with MOS.  It took him about two minutes to figure it out because he didn’t get down into the weeds…. the answer?

JOB_QUEUE_PROCESSES.  yep.  set to ZERO.  Not too many scheduler jobs are going to run with that setting.