Background process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Background process

  1. #1
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47

    Question Background process

    Recently i have created a new database in Solaris using scripts manually. I could find a process called "cjq0" ???

    I have created other databases in the same server through DBCA and it did not create the above process?

    I am not clear under what circumstances they are created and why?

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    This is job queue coordinator process. This process will not start if you put the parameter JOB_QUEUE_PROCESSES =0. CJQ0 dynamically spawns job queue slave processes (J000J999) to run the jobs.

    More details see,
    http://download-east.oracle.com/docs...20/process.htm
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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