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.