Re: OraclePR2 process 100% -> System hangs

From: iositan <iositan_at_sprint.ca>
Date: Thu, 16 Sep 1999 14:08:01 -0400
Message-ID: <37E13201.970A3FE@sprint.ca>

binoy wrote:

> In article <7roh1l$kuu$1_at_nnrp1.deja.com>,
> binoy <binoy.james_at_usa.net> wrote:
> > Folks,
> > ....
> > Occassionally an user will run a report with a really horrendous
> > selection criteria that takes one of the Oracle shadow processes to
> > 100% CPU utilization on the DB server. When this happens, SAP becomes
> > very sluggish and users transactions are stuck and noone can login
> > ......
>
> I meant to say 100% utilitization of one cpu.
> --
> binoy
> binoyjames_at_sprintmail.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Hi,

With no other informaton, except what you have told us, if everything else is OK, ie:

- you've analyzed all other informations regarding statistics on the server
- there is no corruption on the database
- the querry was optimizede, so the execution plan is correct
- you have changed the degree of parallelism to an apppropirate one (you

have alot of CPU-s there)
- in youre execution plan everything is OK,

try :

1. analyze your schema with compute (if possible) or with estimate and an appropriate percentage
2. analyze once again all your database to detect any corruption (dbverify) if any

If nothing help, please provide us more info regarding statistics, and this special querrry.

Bye Received on Thu Sep 16 1999 - 13:08:01 CDT