Home » RDBMS Server » Server Administration » Oracle Scheduled Jobs. (Window Server 2003)
Oracle Scheduled Jobs. [message #422216] Tue, 15 September 2009 02:33 Go to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Hi All,

I am facing one problem relating oracle scheduled jobs. I have scheduled different oracle jobs in my database when these jobs run my database get hang(it will not allow any user to connect to database and if we execute any query it will take long time to finish the execution.

Please help on solving this problem.



Re: Oracle Scheduled Jobs. [message #423231 is a reply to message #422216] Tue, 22 September 2009 23:15 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
1. Stop those jobs
SQL> Execute dbms_job.remove(xx); -- if you used dbms_job to submit them
SQL> 
begin
dbms_scheduler.drop_job(
job_name=>'JOB_NAME',
force=>true);
end;
/
begin
dbms_scheduler.drop_schedule(
schedule_name=>'SCHEDULE_NAME',
force=>true);
end;
/
begin
dbms_scheduler.drop_program(
program_name=>'PROGRAM_NAME',
force=>true);
end;
/
-- If you used dbms_scheduler


The views:
dbms_job
dba_jobs


dbms_scheduler
dba_scheduler_job_run_details
DBA_SCHEDULER_JOBS
DBA_SCHEDULER_RUNNING_JOBS
DBA_SCHEDULER_JOB_LOG
DBA_SCHEDULER_JOBS


2. Using content of what column, program in dbms_scheduler to detect what's sql/proc/func caused db hang. Trace them by explain table, tkprof..
Previous Topic: Database Physical Layout.
Next Topic: how to perform manual redo log switch
Goto Forum:
  


Current Time: Mon Jul 01 01:13:25 CDT 2024