10gR1 SLES-9 Possible parallelism issue

Suse-Oracle gurus,


During a 64-bit conversion I completed on a new quad socket
dual core DL 580 running SLES-9 SP3 and 10.1.0.5 RAC over
Polyserve CFS this weekend, I observed
that only 4 CPUs were doing anything (other than being idle)
during the CPU
intensive recompile portion.  I have done probably over a
hundred database
upgrade on multiprocessor machines, and generally find that
recompiling
invalidated objects works best (completes in the shortest
time) when using a
parallelism of 4 times the number of CPU cores.  Since we
have 8 cores on
the 580s, I used a parallelism of 32.  I could not complete
the conversion
in RAC mode, so I could only use one machine.



utlrcmp.sql

exec utl_recomp.recomp_parallel(32);



Usually when I kick off a recompile in this manner, I see 32
job workers kicked
off at the database level, and when watching top, I can see
32 processes (on
linux, make the xterm window longer) running at high CPU
utilization.


Are system setting or kernel parameter (sysctl.conf) that
might be only allowing 4 processes to run on CPU
simultaneously?  I am not
concerned as much about the recompile time as that when we
turn on the
64-bit database in production, only 4 CPU cores will do any
work, and the other
4 will sit around idle.  The sysadmins indicate they built a
kernel with “make
–j 32” and saw at least 12 instances of gcc running
concurrently.



I am hoping this is not a Xeon limitation.  Last time I did
a 64-bit
conversion on an Opteron based HP DL 585 running SLES-9, I
saw fantastic
performance on the recompile, and 32 oracle processes were
seen via top as
described above.

Thanks,
-Michael Taylor



       
____________________________________________________________
________________________
Take the Internet to Go: Yahoo!Go puts the Internet in your
pocket: mail, news, photos & more. 
http://mobile
.yahoo.com/go?refer=1GNXIC

SuSE guru's - 

I have a question I hope will be easily answered.  On our
production server,
SLES-9, we have two ports that are open and we can't find
out what is
opening them, or why.  I also have been unable to find how
to close the
ports.

I ran nmap on them and got the following:

oraprd:~ # nmap -p 12345 oraprd

Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 EDT
Interesting ports on oraprd.raclocal.com (10.119.8.48):
PORT      STATE SERVICE
12345/tcp open  NetBus

Nmap run completed -- 1 IP address (1 host up) scanned in
0.330 seconds
oraprd:~ # nmap -p 32774 oraprd

Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 EDT
Interesting ports on oraprd.raclocal.com (10.119.8.48):
PORT      STATE SERVICE
32774/tcp open  sometimes-rpc11

Nmap run completed -- 1 IP address (1 host up) scanned in
0.330 seconds

I would appreciate any help or insights as to what I can do
to either
identify why they are open or how to close them.

Thanks
Craig Ward



-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

fuser <port_number>/tcp is your friend.

It will show  process, which keeps port open (but better
run, first

 netstat -an | grep tcp | grep LISTEN

to see if port is really open.)

----- Original Message ----- 
From: "Craig Ward" <cwardoraclexperts.com>
To: <suse-oraclesuse.com>
Sent: Thursday, October 04, 2007 11:04 AM
Subject: [suse-oracle] Open ports on Suse linux


> SuSE guru's -
>
> I have a question I hope will be easily answered.  On
our production 
> server,
> SLES-9, we have two ports that are open and we can't
find out what is
> opening them, or why.  I also have been unable to find
how to close the
> ports.
>
> I ran nmap on them and got the following:
>
> oraprd:~ # nmap -p 12345 oraprd
>
> Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> EDT
> Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> PORT      STATE SERVICE
> 12345/tcp open  NetBus
>
> Nmap run completed -- 1 IP address (1 host up) scanned
in 0.330 seconds
> oraprd:~ # nmap -p 32774 oraprd
>
> Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> EDT
> Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> PORT      STATE SERVICE
> 32774/tcp open  sometimes-rpc11
>
> Nmap run completed -- 1 IP address (1 host up) scanned
in 0.330 seconds
>
> I would appreciate any help or insights as to what I
can do to either
> identify why they are open or how to close them.
>
> Thanks
> Craig Ward
>
>
>
> -- 
> To unsubscribe, email: suse-oracle-unsubscribesuse.com
> For additional commands, email: suse-oracle-helpsuse.com
> Please see http://www.suse.com/oracl
e/ before posting
>
> 


-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

Alexei,

I ran the commands you suggested and was able to find the
one processes
owner.  The  other one though came up with the folling:

oraprd:~ # fuser 32774/tcp
here: 32774

As there is no process id number, I don't know how to track
this any
further.  I would appreciate any other suggestions.

Thanks
Craig E. Ward
803-817-6438

-----Original Message-----
From: Alexei_Roudnev [mailto:Alexei_Roudnevexigengroup.com] 
Sent: Friday, October 05, 2007 12:03 AM
To: Craig Ward; suse-oraclesuse.com
Subject: Re: [suse-oracle] Open ports on Suse linux

fuser <port_number>/tcp is your friend.

It will show  process, which keeps port open (but better
run, first

 netstat -an | grep tcp | grep LISTEN

to see if port is really open.)

----- Original Message ----- 
From: "Craig Ward" <cwardoraclexperts.com>
To: <suse-oraclesuse.com>
Sent: Thursday, October 04, 2007 11:04 AM
Subject: [suse-oracle] Open ports on Suse linux


> SuSE guru's -
>
> I have a question I hope will be easily answered.  On
our production 
> server,
> SLES-9, we have two ports that are open and we can't
find out what is
> opening them, or why.  I also have been unable to find
how to close the
> ports.
>
> I ran nmap on them and got the following:
>
> oraprd:~ # nmap -p 12345 oraprd
>
> Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> EDT
> Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> PORT      STATE SERVICE
> 12345/tcp open  NetBus
>
> Nmap run completed -- 1 IP address (1 host up) scanned
in 0.330 seconds
> oraprd:~ # nmap -p 32774 oraprd
>
> Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> EDT
> Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> PORT      STATE SERVICE
> 32774/tcp open  sometimes-rpc11
>
> Nmap run completed -- 1 IP address (1 host up) scanned
in 0.330 seconds
>
> I would appreciate any help or insights as to what I
can do to either
> identify why they are open or how to close them.
>
> Thanks
> Craig Ward
>
>
>
> -- 
> To unsubscribe, email: suse-oracle-unsubscribesuse.com
> For additional commands, email: suse-oracle-helpsuse.com
> Please see http://www.suse.com/oracl
e/ before posting
>
> 


-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting


-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

It looks like RPC stuff. What does 'rpcinfo -p' return?

On Fri, Oct 05, 2007 at 02:46:19PM -0400, Craig Ward wrote:
> Alexei,
> 
> I ran the commands you suggested and was able to find
the one processes
> owner.  The  other one though came up with the
folling:
> 
> oraprd:~ # fuser 32774/tcp
> here: 32774
> 
> As there is no process id number, I don't know how to
track this any
> further.  I would appreciate any other suggestions.
> 
> Thanks
> Craig E. Ward
> 803-817-6438
> 
> -----Original Message-----
> From: Alexei_Roudnev [mailto:Alexei_Roudnevexigengroup.com] 
> Sent: Friday, October 05, 2007 12:03 AM
> To: Craig Ward; suse-oraclesuse.com
> Subject: Re: [suse-oracle] Open ports on Suse linux
> 
> fuser <port_number>/tcp is your friend.
> 
> It will show  process, which keeps port open (but
better run, first
> 
>  netstat -an | grep tcp | grep LISTEN
> 
> to see if port is really open.)
> 
> ----- Original Message ----- 
> From: "Craig Ward" <cwardoraclexperts.com>
> To: <suse-oraclesuse.com>
> Sent: Thursday, October 04, 2007 11:04 AM
> Subject: [suse-oracle] Open ports on Suse linux
> 
> 
> > SuSE guru's -
> >
> > I have a question I hope will be easily answered. 
On our production 
> > server,
> > SLES-9, we have two ports that are open and we
can't find out what is
> > opening them, or why.  I also have been unable to
find how to close the
> > ports.
> >
> > I ran nmap on them and got the following:
> >
> > oraprd:~ # nmap -p 12345 oraprd
> >
> > Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> > EDT
> > Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> > PORT      STATE SERVICE
> > 12345/tcp open  NetBus
> >
> > Nmap run completed -- 1 IP address (1 host up)
scanned in 0.330 seconds
> > oraprd:~ # nmap -p 32774 oraprd
> >
> > Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05 
> > EDT
> > Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> > PORT      STATE SERVICE
> > 32774/tcp open  sometimes-rpc11
> >
> > Nmap run completed -- 1 IP address (1 host up)
scanned in 0.330 seconds
> >
> > I would appreciate any help or insights as to what
I can do to either
> > identify why they are open or how to close them.
> >
> > Thanks
> > Craig Ward

-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

The rpcinfo -p returned the following:


oraprd:~ # rpcinfo -p
   program vers proto   port
    100000    2   tcp    111  portmapper
    100000    2   udp    111  portmapper
    100024    1   udp  32771  status
    100021    1   udp  32771  nlockmgr
    100021    3   udp  32771  nlockmgr
    100021    4   udp  32771  nlockmgr
    100024    1   tcp  32774  status
    100021    1   tcp  32774  nlockmgr
    100021    3   tcp  32774  nlockmgr
    100021    4   tcp  32774  nlockmgr
    100003    2   udp   2049  nfs
    100003    3   udp   2049  nfs
    100227    3   udp   2049  nfs_acl
    100003    2   tcp   2049  nfs
    100003    3   tcp   2049  nfs
    100227    3   tcp   2049  nfs_acl
    100005    1   udp    997  mountd
    100005    1   tcp    998  mountd
    100005    2   udp    997  mountd
    100005    2   tcp    998  mountd
    100005    3   udp    997  mountd
    100005    3   tcp    998  mountd

The port 32774 is included in this.  I am not very
knowledgeable in this
area.  Is this normal or is it an area of security concern? 
How does rpc
get invoked and where does it decide what ports it will
use?

Thanks again for all the help.  All y'all have been very
helpful.

Thanks
Craig E. Ward
803-517-0217 

-----Original Message-----
From: Konstantin 'Kastus' Shchuka [mailto:kastusepocrates.com] 
Sent: Friday, October 05, 2007 4:46 PM
To: suse-oraclesuse.com
Subject: Re: [suse-oracle] Open ports on Suse linux

It looks like RPC stuff. What does 'rpcinfo -p' return?

On Fri, Oct 05, 2007 at 02:46:19PM -0400, Craig Ward wrote:
> Alexei,
> 
> I ran the commands you suggested and was able to find
the one processes
> owner.  The  other one though came up with the
folling:
> 
> oraprd:~ # fuser 32774/tcp
> here: 32774
> 
> As there is no process id number, I don't know how to
track this any
> further.  I would appreciate any other suggestions.
> 
> Thanks
> Craig E. Ward
> 803-817-6438
> 
> -----Original Message-----
> From: Alexei_Roudnev [mailto:Alexei_Roudnevexigengroup.com] 
> Sent: Friday, October 05, 2007 12:03 AM
> To: Craig Ward; suse-oraclesuse.com
> Subject: Re: [suse-oracle] Open ports on Suse linux
> 
> fuser <port_number>/tcp is your friend.
> 
> It will show  process, which keeps port open (but
better run, first
> 
>  netstat -an | grep tcp | grep LISTEN
> 
> to see if port is really open.)
> 
> ----- Original Message ----- 
> From: "Craig Ward" <cwardoraclexperts.com>
> To: <suse-oraclesuse.com>
> Sent: Thursday, October 04, 2007 11:04 AM
> Subject: [suse-oracle] Open ports on Suse linux
> 
> 
> > SuSE guru's -
> >
> > I have a question I hope will be easily answered. 
On our production 
> > server,
> > SLES-9, we have two ports that are open and we
can't find out what is
> > opening them, or why.  I also have been unable to
find how to close the
> > ports.
> >
> > I ran nmap on them and got the following:
> >
> > oraprd:~ # nmap -p 12345 oraprd
> >
> > Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05

> > EDT
> > Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> > PORT      STATE SERVICE
> > 12345/tcp open  NetBus
> >
> > Nmap run completed -- 1 IP address (1 host up)
scanned in 0.330 seconds
> > oraprd:~ # nmap -p 32774 oraprd
> >
> > Starting nmap 3.50 ( http://www.insecure.org
/nmap/ ) at 2007-10-04 14:05

> > EDT
> > Interesting ports on oraprd.raclocal.com
(10.119.8.48):
> > PORT      STATE SERVICE
> > 32774/tcp open  sometimes-rpc11
> >
> > Nmap run completed -- 1 IP address (1 host up)
scanned in 0.330 seconds
> >
> > I would appreciate any help or insights as to what
I can do to either
> > identify why they are open or how to close them.
> >
> > Thanks
> > Craig Ward

-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting



-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting