RE: too many ora_pXXX pop-up?

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Mon, 4 Jan 2010 08:44:29 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D379CE941AA_at_SPOBMEXC14.adprod.directory>

Parallel processes. If a table/index has parallelism set, or the parallel hint is specified in the query, you'll get your SELECT statement broken down among those parallel processes.

Some things to check:

Look at DEGREE & INSTANCES from DBA_TABLES and DBA_INDEXES where these are > 1. If DEGREE > 1 then parallelism will be used as long as parallelism is enabled in the instance.

Check parallel_max_servers in v$parameter

Here's some documentation:

Using Parallel Execution
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/usingpe.htm

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com  

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Monday, January 04, 2010 8:34 AM
To: oracle-l_at_freelists.org
Subject: too many ora_pXXX pop-up?

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 04 2010 - 08:44:29 CST