Re: ORA-12500 error when many users connected

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Mon, 18 Jan 1999 16:19:22 +0100
Message-ID: <77vjhd$e3e$1@korweta.task.gda.pl>

Igor Karasik wrote in message <36A3446A.4F49AED6_at_mercury.co.il>...
>I checked that Oracle process doesn't exceeded 800 Mb,
>also NT4 from SP3 can work with 3 Gb memory per process.

I don't think that size oracle process handling 1000 concurrent users is below 1GB. What metrics did you use ? See working set and virtual size. I checked oracle process on NT handling up to 50 concurrent connections with sga about 60MB. Peak virtual size is about 280MB...

--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Mon Jan 18 1999 - 09:19:22 CST