Home » RDBMS Server » Server Administration » Running a query from 20 sessions concurrently (Oracle 11.2.0.4)
Running a query from 20 sessions concurrently [message #649045] Thu, 10 March 2016 11:24 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hi Experts,

I have a question about how to simulate concurrency. Suppose I want to run the following sql from 20 different sessions at the same time in an automated way at a specified time like say 2 pm, how to do that:

SELECT * FROM EMP WHERE DEPTNO=10;


I will be thankful for some suggestion in this regard.

Thanks,
OrauserN

[Updated on: Thu, 10 March 2016 11:25]

Report message to a moderator

Re: Running a query from 20 sessions concurrently [message #649046 is a reply to message #649045] Thu, 10 March 2016 11:29 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Just do it with shell scripts. If you read this,
http://www.orafaq.com/node/2904
you'll see the technique I used to run a procedure in a hundred concurrent sessions.
Re: Running a query from 20 sessions concurrently [message #649048 is a reply to message #649046] Thu, 10 March 2016 11:54 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thanks a lot John!
Previous Topic: Partitioning existing Index Organised Table - [ORA-14046]
Next Topic: Useful Tablespace Usage
Goto Forum:
  


Current Time: Sat Jan 20 14:20:22 CST 2018

Total time taken to generate the page: 0.01141 seconds