Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!news.nl.colt.net!newsgate.cistron.nl!news2.euro.net!feeder1.cambrium.nl!feed.tweaknews.nl!138.199.65.86.MISMATCH!sn-ams-06!sn-xt-ams-04!sn-post-ams-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Restart DBMS_JOBS Date: Thu, 02 Feb 2006 12:06:43 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1138910802.636171@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 26 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260604 Ben de Boer wrote: > Hi everybody, > We run an Oracle database Version 8.1.7.2.0 on a unix machine. > For some jobs to run we use DBMS_JOBS.SUBMIT ... > Now sometimes, special for short running programs, it will be started a > second time, > after finishing without errors. > Does anybody has some same problems and solved it. > It would be very helpfull, if I know what I can do about it. > I searched this problem also on Meta-link. It is known, but no solution was > given. > > Tnx in advance > > Ben My first thought is that you Oracle version is in desupport and you are missing two patches ... get yourself to at least 8.1.7.4 and then see if the issue continues to exist. A move to 9.2+ would enhance both your performance and your resume. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)