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.
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-l
Received on Tue Nov 13 2012 - 05:16:30 CET

Original text of this message