ora_s000 spinning, maxing out cpu%

From: Allen <allenh_at_starbase.neosoft.com>
Date: 22 Jun 2001 01:44:48 -0500
Message-ID: <1FD80777DFB56995.ADF8421DD947BBED.5C362699D44FD246@lp.airnews.net>

mts, oracle 8.1.7, solaris 7... here are some init.ora parameters:

mts_multiple_listeners = true
mts_service = prod1
mts_servers = 2
mts_max_servers = 10
mts_dispatchers = "TCP,3"
mts_max_dispatchers = 10
mts_listener_address = "(address=(protocol=tcp) (host=service)

(port=1521))"

all is well and good when we startup the database, but after we startup a bunch of apps that connect to it, the ora_s000 starts chewing up HUGE amounts of cpu:

  8262 oracle     1  59  -20  245M  222M sleep    0:44 74.72% oracle
  oracle  8262     1 70 00:39:03 ?        0:36 ora_s000_prod1

Any ideas what could be causing this and how I can fix it? Also, does my init.ora parameters look ok?

Thanks!! Allen Received on Fri Jun 22 2001 - 01:44:48 CDT