Hello All,

I am working in Suse Linux SLES-8 (i386), VERSION = 8.1 and Oracle Version 9.0.1.0.0.

Quite frequently PMON processes start taking 99% of CPU time. To resolve this I was restarting the database for few times thinking it's a temorary problem. But their seems to be some other problem. Statistics are pasted below :

Tasks: 174 total, 3 running, 171 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.3% user, 4.9% system, 0.0% nice, 90.8% idle
Mem: 2068352k total, 2021572k used, 46780k free, 86480k buffers
Swap: 2097136k total, 459236k used, 1637900k free, 1483532k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
397 oracle 25 0 2652 2336 2092 R 99.4 0.1 2650:47 oracle
426 oracle 25 0 2660 2344 2092 R 99.4 0.1 2649:21 oracle

================================================

oracle@hjkhost:/etc> ps -eaf |grep 397
oracle 397 1 15 Mar02 ? 1-20:12:44 ora_pmon_pag
oracle 21262 20641 0 10:01 pts/10 00:00:00 grep 397
oracle@hjkhost:/etc> ps -eaf |grep 426
oracle 426 1 15 Mar02 ? 1-20:11:31 ora_pmon_pag_test
oracle 21264 20641 0 10:01 pts/10 00:00:00 grep 426

I tried to browse metalink but could see the same kind of problem but only in Oracle 8i.

Will appreciate if somebody could suggest a way out...!!!

Thanks , Raj