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.
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.