oracle 817 ora_snp background process

ysjxjf發表於2008-07-22
$ ps -ef|grep ora_
oracle 5996 1 0 16:10:24 - 0:00 ora_lgwr_orapp
oracle 17100 1 0 16:10:24 - 0:00 ora_snp0_orapp
oracle 17558 1 0 16:10:25 - 0:00 ora_snp1_orapp
oracle 19498 1 0 16:10:24 - 0:00 ora_pmon_orapp
oracle 20276 24436 1 16:13:29 pts/1 0:00 grep ora_
oracle 21704 1 0 16:10:24 - 0:00 ora_dbw0_orapp
oracle 21934 1 0 16:10:24 - 0:00 ora_reco_orapp
oracle 22192 1 0 16:10:24 - 0:00 ora_smon_orapp
oracle 22450 1 0 16:10:24 - 0:00 ora_ckpt_orapp
oracle 25832 1 0 16:10:25 - 0:00 ora_s000_orapp
oracle 26832 1 0 16:10:25 - 0:00 ora_d000_orapp
oracle 27090 1 0 16:10:26 - 0:00 ora_arc0_orapp
$

此程式的數目由job_queue_processes初始化引數設定,最大值為36。

在9i及以後,這些程式命名規則改為ora_jnnn_,由CJQ0後臺程式衍生。

[@more@]
$ ps -ef|grep ora_snp
oracle 17100 1 0 16:10:24 - 0:00 ora_snp0_orapp
oracle 17558 1 0 16:10:25 - 0:00 ora_snp1_orapp
oracle 20278 1 0 16:16:20 - 0:00 ora_snp3_orapp
oracle 23568 1 0 16:16:20 - 0:00 ora_snp2_orapp
oracle 27366 1 0 16:16:20 - 0:00 ora_snp4_orapp
oracle 27606 1 0 16:16:20 - 0:00 ora_snp5_orapp
oracle 27864 1 0 16:16:20 - 0:00 ora_snp6_orapp
oracle 28122 1 0 16:16:20 - 0:00 ora_snp7_orapp
oracle 28380 1 0 16:16:20 - 0:00 ora_snp8_orapp
oracle 28638 1 0 16:16:20 - 0:00 ora_snp9_orapp
oracle 28896 1 0 16:16:20 - 0:00 ora_snpa_orapp
oracle 29154 1 0 16:16:21 - 0:00 ora_snpb_orapp
oracle 29412 1 0 16:16:21 - 0:00 ora_snpc_orapp
oracle 29670 1 0 16:16:21 - 0:00 ora_snpd_orapp
oracle 29928 1 0 16:16:21 - 0:00 ora_snpe_orapp
oracle 30186 1 0 16:16:21 - 0:00 ora_snpf_orapp
oracle 30444 1 0 16:16:21 - 0:00 ora_snpg_orapp
oracle 30702 1 0 16:16:22 - 0:00 ora_snph_orapp
oracle 30960 1 0 16:16:22 - 0:00 ora_snpi_orapp
oracle 31218 1 0 16:16:22 - 0:00 ora_snpj_orapp
oracle 31476 1 0 16:16:23 - 0:00 ora_snpk_orapp
oracle 31734 1 0 16:16:23 - 0:00 ora_snpl_orapp
oracle 31992 1 0 16:16:23 - 0:00 ora_snpm_orapp
oracle 32250 1 0 16:16:23 - 0:00 ora_snpn_orapp
oracle 32508 1 0 16:16:24 - 0:00 ora_snpo_orapp
oracle 32766 1 0 16:16:24 - 0:00 ora_snpp_orapp
oracle 32768 1 0 16:16:24 - 0:00 ora_snpq_orapp
oracle 33026 1 0 16:16:24 - 0:00 ora_snpr_orapp
oracle 33284 1 0 16:16:25 - 0:00 ora_snps_orapp
oracle 33542 1 0 16:16:25 - 0:00 ora_snpt_orapp
oracle 33800 1 0 16:16:25 - 0:00 ora_snpu_orapp
oracle 34058 1 0 16:16:25 - 0:00 ora_snpv_orapp
oracle 34316 1 0 16:16:26 - 0:00 ora_snpw_orapp
oracle 34574 1 0 16:16:26 - 0:00 ora_snpx_orapp
oracle 34832 1 0 16:16:26 - 0:00 ora_snpy_orapp
oracle 35348 1 0 16:16:26 - 0:00 ora_snpz_orapp
oracle 35610 24506 0 16:17:00 pts/1 0:00 grep ora_snp
$
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
job_queue_interval integer 60
job_queue_processes integer 36
SQL> alter system set job_queue_processes=40 ;
alter system set job_queue_processes=40
*
ERROR at line 1:
ORA-00068: invalid value 40 for parameter job_queue_processes, must be between
0 and 36

SQL>

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-1007644/,如需轉載,請註明出處,否則將追究法律責任。

相關文章