OraclePR2 process 100% -> System hangs

From: binoy <binoy.james_at_usa.net>
Date: Wed, 15 Sep 1999 16:21:24 GMT
Message-ID: <7roh1l$kuu$1@nnrp1.deja.com>

Folks,

DB Server: Sun E10K, 20CPU, 14Gb Memory, 1.4Tb database, Solaris 2.51, Oracle 7.3.4. SAP 3.1h/3.1i kernel patch 244

App Servers: Sun E10K, 3Cpu (avg), 8Gb, Solaris 2.6, SAP 3.1h, around 1400 concurrent users, 6200 total named users.

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 till either the process terminates by itself or is terminated.

Has anyone else seen or heard about this type of behavior or can provide any info on how to tackle this problem?

Thanks,
Binoy.
binoyjames_at_sprintmail.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 11:21:24 CDT