Results 1 to 2 of 2

Thread: DBMS_JOB module

  1. #1
    Join Date
    Jul 2014

    Unanswered: DBMS_JOB module


    I have a question regarding the DBMS_JOB module.
    1)can some one tel me the number of calls(procedure calls) scheduling inside a job, runs in a serial process or parallel process.
    2)Max no. of Number of calls, i can give inside one job.
    3)I have a 100 tables , if I create one job for one table , i mean for 100 tables, i l prepare 100 jobs(in case of serial processing). Will they affect my system performance.


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    1) You can only run one statement per job. I would assume that jobs run in parallel.
    2) see Number 1
    3) Of course they will affect performance, resources will be needed to perform the jobs. The question is how poorly do the jobs perform. If they are optimal, then you should be fine with what they do on the server.


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts