What is'QMNO ' and 'CJQ0' Processes ?...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What is'QMNO ' and 'CJQ0' Processes ?...

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    What is'QMNO ' and 'CJQ0' Processes ?...

    Hello all

    When i try to do the following command ...

    **********************************************
    SQL> select program from v$session;

    PROGRAM
    ------------------------------------------------
    oracle@ora22.dpip.state.nc.us (PMON)
    oracle@ora22.dpip.state.nc.us (DBW0)
    oracle@ora22.dpip.state.nc.us (LGWR)
    oracle@ora22.dpip.state.nc.us (CKPT)
    oracle@ora22.dpip.state.nc.us (SMON)
    oracle@ora22.dpip.state.nc.us (RECO)
    oracle@ora22.dpip.state.nc.us (CJQ0)
    oracle@ora22.dpip.state.nc.us (QMN0)
    JDBC Thin Client
    JDBC Thin Client
    sqlplus@ora22.dpip.state.nc.us (TNS V1-V3)

    PROGRAM
    ------------------------------------------------
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    JDBC Thin Client
    jrew.exe

    21 rows selected.

    **********************************

    What is'QMNO ' and 'CJQ0' Processes ?...


    Sun 5.8/Oracle9i

    Thanks
    Ron

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    CJQn - Job queue coordinator background process
    QMNn - Queue monitor background process

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    or see here for bkground processes
    http://download-west.oracle.com/docs...rocs.htm#11872
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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