large pool always filling up

From: Mr Boombastic <shaggy_at_popstar.com>
Date: 29 Nov 2004 12:10:18 -0800
Message-ID: <76dee8e3.0411291210.5b03b342@posting.google.com>

Hello

We are running an Oracle 8.1.7.4 database in production and we have a problem on one of our databases where the large pool is always filling up and on an almost daily basis gets to more than 90 - 100 % full. How do we identify any problem queries? Statspack info on the large pool is limited, as is anything on Metalink.

And yes, we use MTS on the database. I'm not sure where to start the tuning process really as previous investigations have all yielded a blank (where we mostly used Statspack for analysis).

One possible avenue i have in mind is to investigate the dispatcher process (v$dispatcher, v$dispatcher_rate) and also identifying any shared server contention. Would reducing any MTS help our issue?

Im not sure where else to look really. Maybe an experienced DBA out there can help and point me in the right direction? Received on Mon Nov 29 2004 - 14:10:18 CST