Database Tuning (MOSC)

MOSC Banner

log file sync

edited Jun 25, 2014 5:00AM in Database Tuning (MOSC) 6 commentsAnswered

I attached awr report, our database was hanging, log file sync was the second top event. I reviewed the the report, one insert statement had been executed 689036 times. Do you think it was this one to cause log file sync. Executions  Rows Processed Rows per Exec Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text 689,036 689,033 1.00 53.40 97.4 1.4 4f68wgtu7aavv fglcorba@pclcap01 (TNS V1-V3)  insert into tmp_consump VALUES... Any way to tie this to an application or user?  How can I trap this insert? Thanks.

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