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

[vr76413]

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

[Sameer]

CJQn - Job queue coordinator background process
QMNn - Queue monitor background process

[Tarry]

or see here for bkground processes
http://download-west.oracle.com/docs...rocs.htm#11872