Oracle-L: RE: creating test sessions

From: <Jared.Still_at_radisys.com>
Date: Thu, 25 Sep 2003 15:19:35 -0800
Message-ID: <F001.005D115B.20030925151935@fatcity.com>

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_at_espn.com> Sent by: ml-errors_at_fatcity.com
09/25/2003 12:44 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_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-----
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

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_at_billing-components.com>
Sent by: ml-errors_at_fatcity.com
09/25/2003 09:54 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L 
<ORACLE-L_at_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_at_billing-components.com INET: A.Bahar_at_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_at_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).

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_at_fatcity.com for clarification. --=_mixed 007A527C88256DAC_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_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_at_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).

text/plain attachment: InterScan_Disclaimer.txt

Received on Thu Sep 25 2003 - 18:19:35 CDT