Oracle processes not dying, taking up all my CPU!

[Joe Robinson_2]

would appreciate if anyone can point me in the right direction to troubleshoot this; I don't really want to be killing processes but otherwise the system slows to a crawl...

[Fabian Briseño]

Hey joe.
1. Check to see if its oracle patch related.

2. Check to see if the kernel parameters are correct.

3. check too see if it's unix patch related.

By the way, what O.S. you are using and version, what oracle version are you utilizing.

[SANTOSH S. MHASKAR]

Joe,

Pl. elaborate more of ur problem .
Check oracle/os patches and kernel parameters
are as per mentioned by oracle.

-Santosh

[Chan 007]

Joe,

What do you mean by oracle process not die-ing?

Are you trying to kill it? What process?

E.g. oracle has pmon, smon, listener etc.

check your system and keep moniroting for any rouge process or zomie ones.

Check the process that takes more CPU, use kill -15 instead of kill -9.

The better solution is to shutdown and you must not kill a oracle process, as this will currupt you database. Ask your DBAs to shutdown it first.

Once they restart this problem should be solved, then you keep mornitoring the system for next 2 hrs for any similar problem.

Has it started just like that, or did you carry out any patching or any upgrade in last 2 days?

Chan

[Steven E. Protter]

Shalom,

Most comon cause of this is not meeting Oracle guidelines for pre-installation steps. Kernel parameters and OS patches.

See that these steps are met, relink Oracle and the problem may cease.

Knowing you OS version and Oracle version would be helpful in providing further assistance.

SEP

[Joe Robinson_2]

I'm running 11.00, Oracle 9i.

The problem occurred in the last month, and the only thing that changed in that period WAS Oracle patches being applied; I'll check into the Oracle patches on Metalink and see if I can't find something there, as well.

[Joe Robinson_2]

Should have also related that these are oracle user processes, not pmon, smon, listener, etc.

[Joe Robinson_2]

Also, this system load (OS & DB) has been stable for some time (years); the only thing that has changed recently has been some Oracle security patches...

[Chan 007]

Joe,

What about the swap,memory & netstat? I hope they are all OK.

I assume then double check your network related things, use netstat and check for established/waiting etc.

Check for the patch compatibility with 11.00

Cheers
Chan

[Joe Robinson_2]

swap, memory, and netstat appear to be ok; on excessive usage has been noted.