Database Tuning (MOSC)

MOSC Banner

wait events while testing a insert procedure

edited Feb 2, 2016 4:01AM in Database Tuning (MOSC) 10 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center