Re: Oracle Server - HELP HELP

Could it be due to a memory constraint issue rather than high CPU utilization by Oracle? Check init.ora or do a "show parameters" in sqlplus and verify that the memory allocation to the various caches and pools are same as before. It could be that somehow you've allocated more memory to the Oracle instance and now you're constrained on the physical memory of the server. Assuming you're running in dedicated server mode, each server process spawned consumes extra memory so this might cause other daemon processes like telnet server to not function efficiently.

Cheers,
Dave

"jj" <14g_at_hongkong.com> wrote in message news:bbsi0q$i464_at_rain.i-cable.com...
> Dear everybody,
>
> After i upgrade my oracle to 8.1.7, i encounter a problem that some Oracle
> process consume high cpu utilization. It makes no one can connect to the
> Oracle.
>
> When i want to check what the process is running, the process completed
and
> next process started to consume CPU resources.
> The problem disappear when i restart the Oracle
>
> Can anyone tell me what's wrong?
> How can i trace this problem?
>
> Regards,
> Lewis_at_zone1511.net
>
>
Received on Sat Jun 07 2003 - 12:46:20 CDT