Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8Q0sUp06895 for ; Thu, 25 Sep 2003 19:54:30 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8Q0sPc06886 for ; Thu, 25 Sep 2003 19:54:27 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8PMFUK32309 for oracle-l@orafaq.net; Thu, 25 Sep 2003 15:15:30 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D115A; Thu, 25 Sep 2003 15:14:39 -0800 Message-ID: Date: Thu, 25 Sep 2003 15:14:39 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tanel Poder" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tanel Poder" 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/alternative; boundary="----=_NextPart_000_15D3_01C383CB.5DFE6A20" ------=_NextPart_000_15D3_01C383CB.5DFE6A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Jamadagni, Rajendra=20 To: Multiple recipients of list ORACLE-L=20 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 = -------------------------------------------------------------------------= -------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20 -----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=20 if [ -z $1 ]; then=20 #default to 5=20 MAX_CHILD_COUNT=3D5=20 else=20 MAX_CHILD_COUNT=3D$1=20 fi=20 echo Running $MAX_CHILD_COUNT children=20 CHILD_COUNT=3D0=20 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ]=20 do=20 (( CHILD_COUNT =3D CHILD_COUNT + 1))=20 # run your command in the background=20 # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT = 2>/dev/null &=20 echo $CHILD_COUNT=20 done=20 =20 Sent by: ml-errors@fatcity.com=20 09/25/2003 09:54 AM=20 Please respond to ORACLE-L=20 =20 To: Multiple recipients of list ORACLE-L = =20 cc: =20 Subject: createing test sessions=20 I want to run some sql scripts and i need to open 255 session at = same time and=20 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........ --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author:
Sorry, it's either too late or I just = don't get it,=20 how come any instances of this sql script would wait for an=20 alert?
Is there any mechanism inside the sql=20 script?
 
Tanel.
----- Original Message -----
From:=20 Jamadagni, Rajendra =
Sent: Thursday, September 25, = 2003 10:44=20 PM
Subject: RE: creating test = sessions

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


# = get number=20 of processes to run from cmd line

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

echo = Running=20 $MAX_CHILD_COUNT children

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




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

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

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



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

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

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

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


------=_NextPart_000_15D3_01C383CB.5DFE6A20-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003@mail.ee 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).