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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Nov 2004 21:38:19 +0000 (UTC)
Message-ID: <cog4sb$o24$1@hercules.btinternet.com>

Can you explain what the problem is ?

Are you getting error messages like:

    Unable to allocate X bytes in large pool ?

Being 'full' is not inherently a problem - as the alternative could be described as being 'over-allocated'.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

"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?
Received on Mon Nov 29 2004 - 15:38:19 CST

Original text of this message

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