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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 09/25/2003 12:44 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
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
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/25/2003 09:54 AM | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
<encoded content removed -- binaries not allowed by ListGuru>