wait events while testing a insert procedure
Hello ,
I executed below insert procedure from 4-5 sessions with tom user
1 create or replace procedure proc_insert2
2 as
3 begin
4 for i in 1..1000000
5 loop
6 insert into t1 values(i,i+1);
7 commit;
8 end loop;
9* end;
SQL> /
When I see on wait events from v$session_wait following are series of wait events with passage of time while this procedure executes from the multiple sessions.Please help me understand what these wait events would mean corresponding to the insert procedure
select sid,p1,p2,event from v$session_wait where sid in (select sid from v$session where username='TOM');
SID P1 P2 EVENT