Re: Parallel threads is parallel proces

On 8 okt, 20:15, joel garry <joel-ga..._at_home.com> wrote:
> 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
> giveshttp://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

Hello Joel,

I think my mail was not clear enough.

My question is about OS multi threading inside a parallel process. So I have 100 parallel processes with each 258 Os treads.

regards Hans-Peter Received on Thu Oct 09 2008 - 01:41:03 CDT