Parallel threads is parallel proces
From: HansP <hans-peter.sloot_at_atosorigin.com>
Date: Wed, 8 Oct 2008 00:12:10 -0700 (PDT)
Message-ID: <389f6834-d22a-45ef-ad7f-dae3826c0796@f37g2000pri.googlegroups.com>
...
rest..........
Date: Wed, 8 Oct 2008 00:12:10 -0700 (PDT)
Message-ID: <389f6834-d22a-45ef-ad7f-dae3826c0796@f37g2000pri.googlegroups.com>
Hello all,
On one of our Solaris 5.10 systems we have a database running Oracle
10.2.0.3.
We have parallel_max_servers set to 100.
I was surprised to see that a ps -Lef shows 258 parallel threads per parallel server process.
See output below.
ps -ef|grep p00
oracle 20780 1 0 Sep 02 ? 776:08 ora_p007_P835 oracle 20776 1 0 Sep 02 ? 525:32 ora_p005_P835 oracle 20778 1 0 Sep 02 ? 517:40 ora_p006_P835 oracle 20784 1 0 Sep 02 ? 532:26 ora_p009_P835 oracle 20782 1 0 Sep 02 ? 531:50 ora_p008_P835 oracle 20774 1 0 Sep 02 ? 498:28 ora_p004_P835 oracle 20768 1 0 Sep 02 ? 496:59 ora_p001_P835 oracle 20770 1 0 Sep 02 ? 495:00 ora_p002_P835 oracle 20772 1 0 Sep 02 ? 543:02 ora_p003_P835 oramgr 17883 17839 0 09:03:29 pts/3 0:00 grep p00 oracle 20766 1 0 Sep 02 ? 586:22 ora_p000_P835 ps -Lef|grep 20774 oracle 20774 1 1 258 0 Sep 02 ? 451:42 ora_p004_P835 oracle 20774 1 2 258 0 Sep 02 ? 0:12 ora_p004_P835 oracle 20774 1 3 258 0 Sep 02 ? 0:00 ora_p004_P835 oracle 20774 1 4 258 0 Sep 02 ? 8:55 ora_p004_P835 oracle 20774 1 5 258 0 Sep 02 ? 0:05 ora_p004_P835 oracle 20774 1 6 258 0 Sep 02 ? 9:01 ora_p004_P835 oracle 20774 1 7 258 0 Sep 02 ? 0:05 ora_p004_P835 oracle 20774 1 8 258 0 Sep 02 ? 8:54 ora_p004_P835 oracle 20774 1 9 258 0 Sep 02 ? 0:05ora_p004_P835..
...
rest..........
Does someone know how the parallel threading works?
regards Hans-Peter Received on Wed Oct 08 2008 - 02:12:10 CDT