What are the Oracle backgroud processes

To find out the information on the Oracle backgroud processes there are a couple of ways.

One would be to look use the OS command to find information on the Oracle process/database instance.
"testasm" is the instance name in this case.

isvp14_ora> ps -ef | grep _testasm   oracle  9568370        1   0 15:05:04      -  0:02 ora_smon_testasm   oracle 19071098        1   0 15:05:04      -  0:01 oracle+ASM_asmb_testasm (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))   oracle 19333214        1   0 15:05:03      -  0:08 ora_ckpt_testasm   oracle 19529820        1   0 15:05:03      -  0:15 ora_lgwr_testasm   oracle 19595362        1   0 15:05:03      -  0:40 ora_dbw0_testasm   oracle 19660900        1   0 15:05:03      -  0:01 ora_mman_testasm   oracle 19726434        1   0 15:05:03      -  0:33 ora_dia0_testasm   oracle 19857512        1   0 15:05:03      -  0:00 ora_psp0_testasm   oracle 19923050        1   0 15:05:03      -  0:00 ora_gen0_testasm   oracle 20316278        1   0 15:05:04      -  0:00 ora_s000_testasm   oracle 20381826        1   0 15:05:03      -  0:22 ora_vktm_testasm   oracle 20578446        1   0 15:05:03      -  0:04 ora_pmon_testasm   oracle 20775082        1   0 15:05:04      -  0:00 ora_d000_testasm   oracle 25296902        1   0 15:05:14      -  0:06 ora_cjq0_testasm   oracle 25559076        1   0 15:05:23      -  0:00 ora_q001_testasm   oracle 25821214        1   0 15:05:13      -  0:00 ora_qmnc_testasm   oracle 25886744        1   0 15:05:04      -  0:00 ora_mark_testasm   oracle 25952282        1   0 15:05:04      -  0:06 ora_mmon_testasm   oracle 26017820        1   0 15:05:04      -  0:00 ora_asmb_testasm   oracle 26083358        1   0 15:05:04      -  0:00 ora_rbal_testasm   oracle 26214454        1   0 15:05:04      -  0:14 ora_mmnl_testasm   oracle 26280002        1   0 15:05:03      -  0:00 ora_diag_testasm   oracle 26345516        1   0 15:10:14      -  0:00 ora_smco_testasm   oracle 26411078        1   0 15:05:03      -  0:00 ora_dbrm_testasm   oracle 26476590        1   0 15:05:04      -  0:00 ora_reco_testasm   oracle 35258456        1   0 09:31:30      -  0:00 ora_w000_testasm   oracle 41156862        1   0 15:05:23      -  0:00 ora_q000_testasm isvp14_ora>

or we could use the information in the v$process table for more accurate information.

SQL> select program from v$process where BACKGROUND=1; PROGRAM ------------------------------------------------ oracle@isvp14_ora.storage.tucson.com (PMON) oracle@isvp14_ora.storage.tucson.com (VKTM) oracle@isvp14_ora.storage.tucson.com (GEN0) oracle@isvp14_ora.storage.tucson.com (DIAG) oracle@isvp14_ora.storage.tucson.com (DBRM) oracle@isvp14_ora.storage.tucson.com (PSP0) oracle@isvp14_ora.storage.tucson.com (DIA0) oracle@isvp14_ora.storage.tucson.com (MMAN) oracle@isvp14_ora.storage.tucson.com (DBW0) oracle@isvp14_ora.storage.tucson.com (LGWR) oracle@isvp14_ora.storage.tucson.com (CKPT) PROGRAM ------------------------------------------------ oracle@isvp14_ora.storage.tucson.com (SMON) oracle@isvp14_ora.storage.tucson.com (RECO) oracle@isvp14_ora.storage.tucson.com (RBAL) oracle@isvp14_ora.storage.tucson.com (ASMB) oracle@isvp14_ora.storage.tucson.com (MMON) oracle@isvp14_ora.storage.tucson.com (MMNL) oracle@isvp14_ora.storage.tucson.com (MARK) oracle@isvp14_ora.storage.tucson.com (W000) oracle@isvp14_ora.storage.tucson.com (Q000) oracle@isvp14_ora.storage.tucson.com (QMNC) oracle@isvp14_ora.storage.tucson.com (SMCO) PROGRAM ------------------------------------------------ oracle@isvp14_ora.storage.tucson.com (CJQ0) oracle@isvp14_ora.storage.tucson.com (Q001) 24 rows selected.

SQL>