Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Found dead multi-threaded server
Hi there,
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.
Jimmy Received on Fri Sep 28 2001 - 15:31:07 CDT