PMON on Oracle9i dB looks like a run away process?

[Mike Blatsos]

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
2 ? 3129 oracle9i 237 20 51264K 3880K run 386:33 100.12 99.95 ora_pmon_bv9i

I have found this PMON process running at a 100% of a processor when the db is idle (no users have connected). it is still in the test phase. And this has occured on 3 different servers on both 11.00 and 11.11. I have installed the patches and kernel changes Oracle gave me for 9i. Any clues??

[harry d brown jr]

What kind of server, type of disk, amount of memory, swapinfo, 32 or 64 bit, kernel parameters?

live free or die
harry

[Brian Crabtree]

I would seriously suggest contacting oracle regarding this. I have never seen pmon run at 100% for very long, and it could be a bug on your system due to a configuration problem. I would also suggest making sure you are at the highest patchset level for the version of oracle 9i you are on.

Brian

[Mike Blatsos]

HP-UX 11.00 64 bit on a N-4004 with 4 GB of memory. On the Oracle web site there are postings that the problem exists but no recommendations. The posting all point to a problem with the listener being 8i, which is what we have. I am trying to find if a DBA dropped the listener without bring down the databases (which should not matter).

# swapinfo -am
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 1964 0 1964 0% 0 - 1 /dev/vg00/lvol2
reserve - 1273 -1273
memory 3200 1816 1384 57%

STRMSGSZ 65535
dbc_max_pct 10
dbc_min_pct 2
max_mem_window 256
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxfiles 2048
maxfiles_lim 2048
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxuprc (NPROC-5)
maxusers 1000
maxvgs 22
msgmax 32768
msgmnb 32768
msgmni (NPROC)
msgseg 32767
msgtql (NPROC)
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile (15*NPROC+2048)
nflocks (NPROC)
ninode (8*NPROC+2048)
nproc 7680
npty 512
nstrpty 512
nstrtel 4096
num_tachyon_adapters 5
semmni (NPROC*2)
semmns ((NPROC*2)*2)
semmnu (NPROC-4)
semvmx 40960
shmmax 2147483648
shmmni 512
vps_ceiling 64

[harry d brown jr]

Mike,

Do you have lsof? If not:

http://hpux.cs.utah.edu/hppd/hpux/Sysadmin/lsof-4.61/

using lsof on the process id find out what files it has open. Also, do you have glance installed? If you never have you can install a trial version (good for about 30 days) and drill into the process to find out what it is doing.

live free or die
harry

[Mike Blatsos]

lsof is installed, but it is a 32 bit app. and will not run on a 64 bit OS.
I am installing the trail of glance.

[Brian Crabtree]

semmni (NPROC*2)
semmns ((NPROC*2)*2)

I dont know if this would cause your problem. However, both of these would appear to be very large. semmni would normally equal around 200, and semmns would normally be around 500 for normal systems.

Brian