Database Tuning (MOSC)

MOSC Banner

logfile sync wait event

edited Sep 10, 2013 4:51AM in Database Tuning (MOSC) 5 commentsAnswered
Any suggrstion please.Import got hung for 30 mins on below wait event but now it's running but very slow.Pls suggest

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

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