Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

stored procedure isolation level transaction tests

invatacelulJun 6 2015 — edited Jun 8 2015

Hello,

I want to study concurrency in Oracle database using pl/sql stored procedures with different transaction isolation levels.

The idea is to send to database a number "n" of concurrent transactions where n can be { 100, 200, 400, 1000} and for each isolation level ( READ COMMITTED, SERIALIZABLE) to determine how many transactions committed, how many dirty data, time of execution.

The question is how can I generate n transactions running concurrently on database and how can I get these results. I understand that this task can be achieved both using pl/sql stored proceedures in database or from within a JSP Java web application. Advantages/disadvantages?

I have to mention that I'm a begginner in Oracle..

Thank you in advance.

This post has been answered by Zlatko Sirotic on Jun 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2015
Added on Jun 6 2015
3 comments
902 views