|
Sorry, it's either too late or I just don't get it,
how come any instances of this sql script would wait for an
alert?
Is there any mechanism inside the sql
script?
Tanel.
----- Original Message -----
Sent: Thursday, September 25, 2003 10:44
PM
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 !
# 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
Please respond to ORACLE-L
|
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).
|
