Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> trouble with dbms_job...
Hi!
I've got the following package:
#!/bin/sh
sqlplus -S -L perfstat/perfstat <<-\EOF
create or replace package oadmin_dbstats authid current_user
is
procedure oadmin_analyzedb;
end;
/
show errors;
create or replace package body oadmin_dbstats
is
procedure oadmin_analyzedb
is JobId binary_integer :=NULL; begin dbms_stats.alter_database_tab_monitoring(monitoring=>TRUE); dbms_stats.gather_database_stats(options=>'GATHER AUTO'); dbms_job.submit(job=>JobId,what=>'perfstat.oadmin_dbstats.oadmin_analyzedb;',next_date=>sysdate+(1/144)); commit; end;
(9.2.0.4, RH)
Lots of Greetings!
Volker
Received on Tue Sep 30 2003 - 09:21:34 CDT