Can you run
vmstat 5
in time of this heavy load?
----- Original Message -----
From: "Anton Dischner" <Anton.Dischner@(protected)>
To: "SuSE MailingList" <suse-oracle@(protected)>
Sent: Thursday, January 25, 2007 8:07 AM
Subject: [suse-oracle] shared servers and multiplexing
> Hi,
>
> from time to time we see heavy trashing of our main system.
>
> Its not easy to debug the reason because at this time no
> command will run, no top, no shell etc.
>
> All we can see is very heavy xload for about 5 minutes.
>
> Maybe a user went nuts and is insanely trashing his keyboard ;-)
>
> As we have about 500 sessions (not users) we want to try
> shared servers and multiplexing.
>
> Is it enough to do the following?
>
> alter system set
> dispatchers = '(protocol = tcp)
> (dispatchers = 3)
> (pool=on)'
>
> some other info says to set (multiplex=on)
>
> alter system set
> shared_servers = 2
> max_shared_server = 20
>
> kind regards,
>
> Toni
>
> PS: FSI TX200 S2
> 2 * Xeon EM64T, 3 GHz, 2MB SLC, which shows up as 4*CPU
> System Bus 200 MHz, 24000 BogoMIPS
> 4 GB main memory
> 6 * 150 GB harddisc mirrored, Zero Channel Raid LSI 128 MB
> Oracle 10.1.0.5: 20 GB database
>
> --
> +-----------------------------------------------------------------+
> | Anton Dischner, Unix admin, Oracle-DBA Phone: +49 89 70953202|
> | Institut fuer Klinische Chemie Fax : +49 89 70958888|
> | Klinikum Grosshadern Home : +49 89 69708766|
> | Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
> | 81366 Muenchen Germany |
> | Marchioninistr. 15 Anton.Dischner"at"med.uni-muenchen.de |
> +-----------------------------------------------------------------+
>
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
