Re: Parallel threads is parallel proces

On Oct 8, 12:12 am, HansP <hans-peter.sl..._at_atosorigin.com> wrote:
> 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:05
> ora_p004_P835..
> ...
> rest..........
>
> Does someone know how the parallel threading works?
>
> regards Hans-Peter

Googling for:
parallel threads oracle doug burns
gives http://www.slideshare.net/dougburns/introduction-to-parallel-execution/ among other things, which supports what you think about max_parallel_servers. What you may want to do is look at v$pq_slave and see if it agrees with what ps is telling you. It is entirely possible that ps is showing processes pq is done with, but I'm not on that sort of configuration so I can't say for sure. Check out Doug's site, he's a heckuva helpful guy.

jg

--
@home.com is bogus.
"My house isn't a pigsty, it's an Immunity Enhancement Center. " - The
Real Bev