RE: too many ora_pXXX pop-up?
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