oracle - Changing start date for system jobs related to automatic statistics collections in 11g -

-

i have oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production running on windows 2008 r2 somehow got next run dates scheduled jobs set dates in year 2016. jobs created able reset start_date in turn caused next_run_date reset. jobs related oracle automatic statistics collections unable dms_scheduler.set_attribute work changing start_date values.

i tried resetting weekly window's dates per oracle document id 1450173.1 using sql following , did in fact reset values see within dba_scheduler_windows had no change dba_scheduler_jobs

begin dbms_scheduler.set_attribute ( name => '"sys"."monday_window"', attribute => 'start_date', value => '10-jun-15 10.00.00.000000000 pm us/central'); end; /

the job names seeing issue on are:

rse$clean_recoverable_script ora$autotask_clean purge_log sm$clean_auto_split_merge bsln_maintain_stats_job mgmt_stats_config_job

some of lack schedule names if try dbms_scheduler.set_attribute ones have schedule names follow error:

   begin dbms_scheduler.set_attribute ( name => '"sys"."bsln_maintain_stats_sched"', attribute => 'start_date', value => '10-jun-15 12.00.00.000000000 -05:00'); end; error report - ora-27476: "sys.bsln_maintain_stats_sched" not exist ora-06512: @ "sys.dbms_isched", line 4398 ora-06512: @ "sys.dbms_scheduler", line 2892 ora-06512: @ line 2 27476. 00000 -  "\"%s\".\"%s\" not exist" *cause:    database object specified not exist. *action:   reissue command using object exists or create new            object , reissue command.

i did try execute jobs throws error well:

exec dbms_scheduler.run_job('"sys"."bsln_maintain_stats_job"', false) error report - ora-27476: "sys.bsln_maintain_stats_job" not exist ora-06512: @ "sys.dbms_isched", line 185 ora-06512: @ "sys.dbms_scheduler", line 486 ora-06512: @ line 1 27476. 00000 -  "\"%s\".\"%s\" not exist" *cause:    database object specified not exist. *action:   reissue command using object exists or create new            object , reissue command.

tried run dbms_auto_task_immediate.gather_optimizer_stats ran had no change next_run_date values within dba_scheduler_jobs

i have tried using dbms_auto_task_admin.enable , dbms_auto_task_admin.disable 'auto optimizer stats collection' see if perhaps how trigger date resets did not. had suggest me perhaps restart of oracle result in resets of dates since windows start dates did reset , maybe ones in dba_scheduler_jobs somehow in memory restart changed nothing.

so ultimate question how can start_dates or next_run_dates reset?


Comments

Post a Comment

Popular posts from this blog

javascript - oscilloscope of speaker input stops rendering after a few seconds -

-
the following script reads audio user's microphone , renders oscilloscope on html canvas. the source taken example of mozilla developer network: visualizations web audio api and here fiddle: http://jsfiddle.net/b7j8pktp/ mozgetusermedia (note: code has no fork mechanism different browsers: works firefox) it works fine few seconds , stops rendering. whereas works totally stable: http://mdn.github.io/voice-change-o-matic/ the problem can reduced following code. microphone activation icon (next the address bar in firefox) disappears after 5 seconds: navigator.mozgetusermedia({audio: true}, function() {}, function() {} ); ( http://jsfiddle.net/b7j8pktp/2/ ) this known bug in firefox. take stream getusermedia call , hook window so: navigator.mozgetusermedia({audio: true}, function(stream) { window.stream = stream; // rest of code }, function err() { // handle error }); hopefully can fixed soon. problem we're f
Read more

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

-
i'm running nodejs 0.12.3 - gulp 3.10.8 , gulp-nodemon 2.0.3. gulpfile.js : gulp.task('serve', ['build'], function() { gulp.start('fb-flo'); nodemon({ script: paths.server, env: { 'node_env': 'development' }, // env: { 'node_env': 'production' }, execmap: { 'js': 'node_modules/babel/bin/babel-node --stage 1' //es7 cote server }, delay: '0ms', watch: ['src/shared/', 'src/server/'], ignore: ['src/shared/components'], tasks: function (changedfiles) { var tasks = []; changedfiles.foreach(function (file) { if (path.extname(file) === '.jsx' && !~tasks.indexof('bundlejs')) tasks.push('bundlejs'); if (path.extname(file) === '.less' && !~tasks.indexof('compileless')) tasks.push('compileless'); }); return tasks; }
Read more

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

-
i trying make simple python program opening list of webpages user manually download reports site. don't have previous experience preparing exe files.. , i'm in learning process python coding. of done on windows 7 x64 this python code: #!c:/python34/python.exe -u splinter import * import time import os import csv #---------------------------------- raporty = [] open('../raporty.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') raporty.append(r) #--not implemented yet zmienne = [] open('../zmienne.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') zmienne.append(r) print("start") browser = browser(
Read more