Re: large pool always filling up

Thanks for everyone's replies so far.

Jonathan, we don't get messages like the one you mention below. What actually happens is that we constantly run a report on the database which tells us the large pool usage. When we see that we only have x Mb free we start calling the users up and ask them to log off the system if possible. This is our current workaround to the problem.

Would increasing the shared_pool_size and/or the large_pool_size resolve the issue? How can we identify problem queries?

Occasionally users have reported seeing TNS errors which occur at or around the time the large pool is full or nearly full. I dont recall from memory the exact ORA or TNS error number but will post back in this thread when I have the full details hopefully tomorrow.

Although we are on 8.1.7.4 we are in the process of upgrading to 9.2.0.5 in the next couple of months. Im hoping this problem will be resolved as a result of the upgrade but it would be helpful to diagnose the issue rather than clutch at straws and hope that a db upgrade will solve all the problems!!

I'll post full details of how big the large pool and shared pool / sga size is tomorrow when i have full access to the database.

THanks to all the replies so far.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<cog4sb$o24$1_at_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'.
>
>
Received on Tue Nov 30 2004 - 15:27:42 CST