Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: large pool always filling up

Re: large pool always filling up

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 02 Dec 2004 04:49:57 GMT
Message-ID: <V9xrd.131139$5K2.41508@attbi_s03>

"Mr Boombastic" <shaggy_at_popstar.com> wrote in message news:76dee8e3.0411291210.5b03b342_at_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?

Are you using bind variables? I have seen not using bind variables sometimes gives this type of behavior.
Jim Received on Wed Dec 01 2004 - 22:49:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US