Re: Found dead multi-threaded server

From: Philip Ross <philip_ross_at_my-deja.com>
Date: Fri, 28 Sep 2001 22:19:21 +0100
Message-ID: <9p2pi6$eam$1@newsg1.svr.pol.co.uk>

"JimmyN1" <jimmyn1_at_aol.com> wrote in message news:20010928163107.01410.00001123_at_mb-fz.aol.com...
> while users are logging in, take statitics on your large_pool.
>
> select * from v$sgastat;
>
> See if the dead multi-threaded server dies when your large pool runs out
of
> space. I run MTS and for 300 users my large pool is 500MB.

Thanks for your reply. I have set up a process to monitor the large pool values. 'session heap' is currently 4,160,540 bytes, 'free memory' is currently 48,268,260 bytes.

Phil Received on Fri Sep 28 2001 - 16:19:21 CDT