log file sync
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.