Hello Community,
Just to let you know that I have uploaded the presentation file from
the last Meetup.
http://files.meet...
As a follow up on the discussion related to job_queue_processes
init.ora parameter and dbms_scheduler:
I have double checked the version I was working with and it was 10G
(not the 11G as stated):
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production.
I found the following blog entry very useful in the context:
http://ronr.blogs...
"surprisingly, in the different release of oracle that have the Oracle
Scheduler implemented (starting with 10gR1) there are some relations
to be found with the job_queue_processes parameter. Oracle
documentation is very vague on this point with phrases to be found
like 'the job_queue_processes has no effect on the dbms_scheduler
jobs' varying to 'the job_queue_processes has some impact on the
dbms_scheduler jobs'.
And now comes 11.2.0.1 where job_queue_processes = 0 prevents all
scheduled jobs to run..."
Other news is that we are in the negotiation process with Tim Hall
(the man behind http://www.oracle...
) at the moment. He may
speak for us while he is in Sydney this October. We will keep you
posted.
Regards,
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (Sydney Office) - www.pythian.com
http://www.timean...
+61 414252591 - cell (international)
[address removed] - send an email to page me on my mobile
(please use for emergency only out of business hours)
From Sydney (desk phone):
+61 (0)280147452 or +61 (0)280149235 x 277 - office
From US & Canada (desk phone):
+1 [masked] x 277 - office
--------------------
-------------
IMs:
--------------------
-------------
Skype j.velikanovs
AIM pythianvelikanov
GTalk [address removed]
MSN [address removed]
Y! [address removed]
--------------------
-------------
Web resources:
--------------------
-------------
http://otn.oracle...
http://au.linkedi...
--------------------
-------------
--
The best compliment you could give Pythian for our service is a referral.