Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8Q1AmO07601 for ; Thu, 25 Sep 2003 20:10:48 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8Q1Alc07596 for ; Thu, 25 Sep 2003 20:10:47 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h8PMU0mO025486 for ; Thu, 25 Sep 2003 15:32:04 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h8PMKNPE023625 for oracle-l@orafaq.net; Thu, 25 Sep 2003 15:20:23 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D115B; Thu, 25 Sep 2003 15:19:35 -0800 Message-ID: Date: Thu, 25 Sep 2003 15:19:35 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jared.Still@radisys.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jared.Still@radisys.com Subject: RE: creating test sessions Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=_mixed 007A527C88256DAC_=" --=_mixed 007A527C88256DAC_= Content-Type: multipart/alternative; boundary="=_alternative 007A527C88256DAC_=" --=_alternative 007A527C88256DAC_= Content-Type: text/plain; charset="us-ascii" This is actually just an excerpt from a set of scripts that do what you describe. call sqlplus, kicks off a configurable number of sqlplus children via 'host test.sh', all the kids run simultaneously. Do this for 2 iterations to stress test different methods of coding, collect all the stats via Tom Kytes run_stats, compare the stats side by side. Can be kind of fun. Jared "Jamadagni, Rajendra" Sent by: ml-errors@fatcity.com 09/25/2003 12:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: RE: creating test sessions one cool thing about this is you can have all your scripts (that would run in parallel) register to receive an alert. So you startup all sessions but they won't do anything. when you are ready to start processing, from another session you raise alert and commit, all sessions start processing within couple of seconds of each other. Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- Sent: Thursday, September 25, 2003 2:50 PM To: Multiple recipients of list ORACLE-L # get number of processes to run from cmd line if [ -z $1 ]; then #default to 5 MAX_CHILD_COUNT=5 else MAX_CHILD_COUNT=$1 fi echo Running $MAX_CHILD_COUNT children CHILD_COUNT=0 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ] do (( CHILD_COUNT = CHILD_COUNT + 1)) # run your command in the background # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2>/dev/null & echo $CHILD_COUNT done Sent by: ml-errors@fatcity.com 09/25/2003 09:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: createing test sessions I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script..... Help bittee........ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: This is actually just an excerpt from a set of scripts that do what you describe.

call sqlplus, kicks off a configurable number of sqlplus children via 'host test.sh',
all the kids run simultaneously.

Do this for 2 iterations to stress test different methods of coding, collect all the
stats via Tom Kytes run_stats, compare the stats side by side.

Can be kind of fun.

Jared




"Jamadagni, Rajendra" <Rajendra.Jamadagni@espn.com>
Sent by: ml-errors@fatcity.com

 09/25/2003 12:44 PM
 Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
        cc:        
        Subject:        RE: creating test sessions



one cool thing about this is you can have all your scripts (that would run in parallel) register to receive an alert. So you startup all sessions but they won't do anything. when you are ready to start processing, from another session you raise alert and commit, all sessions start processing within couple of seconds of each other.
 
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
Sent: Thursday, September 25, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: createing test sessions

# get number of processes to run from cmd line

if [ -z $1 ]; then
       #default to 5
       MAX_CHILD_COUNT=5
else
       MAX_CHILD_COUNT=$1
fi

echo Running $MAX_CHILD_COUNT children

CHILD_COUNT=0
while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ]
do
       (( CHILD_COUNT = CHILD_COUNT + 1))
       # run your command in the background
       # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2>/dev/null &
       echo $CHILD_COUNT
done



<A.Bahar@billing-components.com>
Sent by: ml-errors@fatcity.com

 09/25/2003 09:54 AM
Please respond to ORACLE-L

       
       To:        Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
       cc:        
       Subject:        createing test sessions




  I want to run some sql scripts and i need to open 255 session at same time and
 these session will run somw sql scripts.

 HOW CAN I OPEN  255 session at the same time ?
 may be a tool , may be shell script.....

Help bittee........
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <A.Bahar@billing-components.com
INET: A.Bahar@billing-components.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--=_alternative 007A527C88256DAC_=-- --=_mixed 007A527C88256DAC_= Content-Type: text/plain; name="InterScan_Disclaimer.txt" Content-Disposition: attachment; filename="InterScan_Disclaimer.txt" Content-Transfer-Encoding: 7bit --=_mixed 007A527C88256DAC_=-- Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster@fatcity.com for clarification. --=_mixed 007A527C88256DAC_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still@radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).