logfile sync wait event
SQL> select event,sid,blocking_session,p1,p1text,p2,p2text,p3,p3text,wait_class,state from v$session where status='ACTIVE' and username<>'SYS';
EVENT SID BLOCKING_SESSION P1 P1TEXT P2 P2TEXT P3 P3TEXT WAIT_CLASS STATE
---------------------------------------------------------------- ---------- ---------------- ---------- ---------------------------------------------------------------- ---------- ---------------------------------------------------------------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- -------------------
log file sync 140 392 104843 buffer# 3799629628 sync scn 0 Commit WAITING
1 row selected.
Regards,
Vishal