Concurrent Manager Program
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Concurrent Manager Program

  1. #1
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175

    Concurrent Manager Program

    There are about 300 jobs submitted to current program within the last hour. The processing is taking a lot of time. Is any way to improve the performance of the concurrent program? How can I expedite the start processing of any job by reducing its priority value? How Can I reset a job that has position 100 to be in position 1 in the concurrent request?
    Thank you in advance for your input.

    C. K.

  2. #2
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    This what I did to get the Concurrent Manager program that ran a job for 7 hours to be completed in just few minutes.

    1. Set up another concurrent manager program
    2. Added additional process to the STANDARD manager so that 4 will run at a time instead of just 3.
    3. Changed the priority on the Receiving Transaction Processor program from 50 to 99
    4. Increased the process and cache size in the init.ora
    5. Purged concurrent requests
    6. Flushed shared pool
    7. Stop and restarted the concurrent manager


    C. K.
    Apps DBA

Posting Permissions

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



Click Here to Expand Forum to Full Width