too many ora_pXXX pop-up?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 4 Jan 2010 06:34:04 -0800 (PST)
Message-ID: <878114.96076.qm_at_web65709.mail.ac4.yahoo.com>

I have ORACLE database 10.2.0.4 on Redhat AS 5.4 (X86-64). Recently I found some time there have process call "ora_pXXX_dbname" will pop up and may up to 128 processes. Those "ora_pxxx_dbanme" will disappear normally after 10 -20 minutes.

Does anyone know what is "ora_pxxx_dbname"? Why it come and why it go?

Why some many processes pop-up?

Thanks.

---

oracle    4653     1  0 17:21 ?        00:00:11 ora_p000_db01
oracle    4655     1  0 17:21 ?        00:00:08 ora_p001_db01
oracle    4657     1  0 17:21 ?        00:00:08 ora_p002_db01
oracle    4659     1  0 17:21 ?        00:00:08 ora_p003_db01
oracle    4661     1  0 17:21 ?        00:00:08 ora_p004_db01
oracle    4663     1  0 17:21 ?        00:00:08 ora_p005_db01
oracle    4665     1  0 17:21 ?        00:00:09 ora_p006_db01
oracle    4667     1  0 17:21 ?        00:00:08 ora_p007_db01
oracle    4669     1  0 17:21 ?        00:00:09 ora_p008_db01

....

oracle    5851     1  0 17:36 ?        00:00:00 ora_p122_db01
oracle    5853     1  0 17:36 ?        00:00:00 ora_p123_db01
oracle    5855     1  0 17:36 ?        00:00:00 ora_p124_db01
oracle    5857     1  0 17:36 ?        00:00:00 ora_p125_db01
oracle    5859     1  0 17:36 ?        00:00:00 ora_p126_db01
oracle    5861     1  0 17:36 ?        00:00:00 ora_p127_db01






      

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 04 2010 - 08:34:04 CST