swingbench connection issue
From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 12 Nov 2012 20:16:30 -0800
Message-ID: <CADsdiQj6yGkGrO=cgXHnpmH8NZAq=Qi4+CoQATFRpahoDsmrRA_at_mail.gmail.com>
Anyone have any idea what might be happening when sessions are connecting and all but a few succeed. After that swingbench (actually charbench) just waits for a long time until those few extra succeed.
j
$ ./one.sh 80
$ vi one.sh
$ ./one.sh 60
$ #./one.sh 100
$ ./one.sh 10
$
Date: Mon, 12 Nov 2012 20:16:30 -0800
Message-ID: <CADsdiQj6yGkGrO=cgXHnpmH8NZAq=Qi4+CoQATFRpahoDsmrRA_at_mail.gmail.com>
Anyone have any idea what might be happening when sessions are connecting and all but a few succeed. After that swingbench (actually charbench) just waits for a long time until those few extra succeed.
Time Users TPM TPS 8:26:26 PM [0/60] 0 0 8:26:27 PM [55/60] 0 0 8:26:28 PM [55/60] 0 0 8:26:29 PM [55/60] 0 0 8:26:30 PM [55/60] 0 0 8:26:31 PM [55/60] 0 0 8:26:32 PM [55/60] 0 0 8:26:33 PM [55/60] 0 0 8:26:34 PM [55/60] 0 0 8:26:35 PM [55/60] 0 0
If I start swingbench with 80 then 78 connect. If I start it up with 10
then say 5 connect.
Is there a timeout before it retries to connect missing sessions?
If so is it modifiable?
(This only happens on one of two databases on my machine - all the more
curious)
I even tried setting up prespawn with the listener but same result.
one.sh just does:
DB="$IP:1521:$SID"
user_count=$1
min=2
max=10
runtime=01
$CHARBENCH -cs $DB -dt thin -u soe -p soe -uc $user_count -min $min -max
$max -rt 0:$runtime -a -v users,tpm,tps
Here are a bunch of tries:
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:25:29 PM [0/60] 0 0 8:25:30 PM [56/60] 0 0 8:25:31 PM [56/60] 0 0
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:25:42 PM [0/60] 0 0 8:25:43 PM [58/60] 0 0 8:25:44 PM [58/60] 0 0 8:25:45 PM [58/60] 0 0 8:25:46 PM [58/60] 0 0
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:25:50 PM [0/60] 0 0 8:25:51 PM [58/60] 0 0 8:25:52 PM [58/60] 0 0 8:25:53 PM [58/60] 0 0 8:25:54 PM [58/60] 0 0
j
$ ./one.sh 80
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:26:04 PM [0/80] 0 0 8:26:05 PM [78/80] 0 0
$ vi one.sh
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:26:16 PM [0/60] 0 0 8:26:17 PM [59/60] 0 0 8:26:18 PM [59/60] 0 0 8:26:19 PM [59/60] 0 0 8:26:20 PM [59/60] 0 0
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:26:26 PM [0/60] 0 0 8:26:27 PM [55/60] 0 0 8:26:28 PM [55/60] 0 0 8:26:29 PM [55/60] 0 0 8:26:30 PM [55/60] 0 0 8:26:31 PM [55/60] 0 0 8:26:32 PM [55/60] 0 0 8:26:33 PM [55/60] 0 0 8:26:34 PM [55/60] 0 0 8:26:35 PM [55/60] 0 0
$ ./one.sh 60
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:29:06 PM [0/60] 0 0 8:29:07 PM [57/60] 0 0 8:29:08 PM [57/60] 0 0 8:29:09 PM [57/60] 0 0 8:29:10 PM [57/60] 0 0 8:29:11 PM [57/60] 0 0
$ ./one.sh 80
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:29:25 PM [0/80] 0 0 8:29:26 PM [69/80] 0 0 8:29:27 PM [69/80] 0 0 8:29:28 PM [69/80] 0 0
$ ./one.sh 100
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:29:33 PM [0/100] 0 0 8:29:34 PM [97/100] 0 0 8:29:35 PM [97/100] 0 0 8:29:36 PM [97/100] 0 0
$ #./one.sh 100
$ ./one.sh 10
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:29:48 PM [0/10] 0 0 8:29:49 PM [3/10] 0 0 8:29:50 PM [3/10] 0 0 8:29:51 PM [3/10] 0 0
$ ./one.sh 20
Author : Dominic Giles Version : 2.4.0.845 Time Users TPM TPS 8:29:55 PM [0/20] 0 0 8:29:57 PM [10/20] 0 0 8:29:58 PM [10/20] 0 0 8:29:59 PM [10/20] 0 0
$
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2012 - 05:16:30 CET