OraFAQ Forum: Server Administration » Running a query from 20 sessions concurrently

Home » RDBMS Server » Server Administration » Running a query from 20 sessions concurrently (Oracle 11.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running a query from 20 sessions concurrently [message #649045]

Thu, 10 March 2016 11:24

orausern
Messages: 826
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

John Watson
Messages: 8457
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.

Report message to a moderator

Re: Running a query from 20 sessions concurrently [message #649048 is a reply to message #649046]

Thu, 10 March 2016 11:54

orausern
Messages: 826
Registered: December 2005

Senior Member

Thanks a lot John!

Report message to a moderator

Previous Topic:	Partitioning existing Index Organised Table - [ORA-14046]
Next Topic:	Useful Tablespace Usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 21 05:47:41 CST 2021