See inline... Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features� Mastering Oracle8i�����������������������
Clark Griswold: Eddie,�has anyone�ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -----Original Message----- Sent: Wednesday, June 12, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Some comments... >> some earlier versions of the db had job bugs where >> the next date was not correctly calculated and thus >> stopped running - typically threw an ora-600 or at >> least a trace file in bdump (as opposed to udump) Is this true in 9i? If so, can you provide any bug numbers we can reference with Oracle? I can't seem to come up with any specific to 9i in Metalink. >> - we're running about 50 jobs at various frequencies >> on 9013 and not experienced anything you've described, >> at which point you're probably saying 'gee thanks' :-) Well, that may be one catch, we are currently on 9011... we have plans to move to 9013, but have not yet for some.... *cough*... very good reasons. Maybe this is an issue with 9011. If I could identify the bug then perhaps I can get Oracle to backport an existing patch. >> - see if the problem still occurs if you explicitly >> - set next date within the job itself, ie 'procx;' >> - becomes 'procx(next_date);' - this is not a great >> - workaround, but it does confirm if the next date value >> - is not being derived correctly by the scheduler itself Tried that, no joy. It's really strange, some jobs will run all the time, others run once, twice, three times maybe and then just never run again. >> - is the interval simple ? the most common errors for >> job timings I've seen are typically dodgey interval >> strings or passing a date to the parms instead of a >> varchar2 Interval is something akin to "sysdate + 5/1440"... doesn't seem to complex. Like I said, this stuff worked fine in 8i, but in 9i it runs a while and dies. Thanks for your thoughts! RF hth connor --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > I've got a TAR open on it now, but slow movement. > > RF > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > Author: Oracle9i New Features� > Mastering Oracle8i����������������������� > > Clark Griswold: Eddie,�has anyone�ever told you that > you're bad luck? > Cousin Eddie: Those were my mother's dying words. > But I guess if your > body's covered in third degree burns, and your > foot's caught in a bear > trap, you tend to start talkin' crazy. > > > > -----Original Message----- > Sent: Monday, June 10, 2002 2:39 PM > To: Multiple recipients of list ORACLE-L > > > We had the same situation and then we use "cron" > that never fails. Now, we > don't trust dbms_job ... I had a TAR open on that, > but can't access it now. > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't > reflect that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion > is an art! > > > -----Original Message----- > Sent: Monday, June 10, 2002 2:13 PM > To: Multiple recipients of list ORACLE-L > > > Anyone run into any problems with the job scheduler > in 9iR1 not kicking > off jobs when they are scheduled? > > We have a situation where a given job (runs every 4 > hours or so) will be > kicked > of successfully 2-3 times, and then on the 4th time > the scheduler does not > kick > it off, next_date is not incremented... it's like > the job just gets lost in > space...This same scheduled job ran fine in 8i. > (this is an 8i to 9i > migrated > database) > > Any thoughts on this? > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
