Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time

Hi Matt,

I would confirm the number of commits by looking at v$sesstat, rather than just doing a count(*) from the table.

If it does look you are comitting more frequently than you thought, then the following is something else to check, from the doco...

"For tables containing LOBs or LONG, BFILE, REF, ROWID,UROWID, or TIMESTAMP columns, rows are inserted individually. The size of the buffer must be large enough to contain the entire row, except for LOB and LONG columns. If the buffer cannot hold the longest row in a table, Import attempts to allocate a larger buffer."

Does your table have any of these datatypes?

HTH, Steve Received on Sat Nov 25 2006 - 07:55:42 CST