Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time
> "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?
No,
SQL> select distinct data_type from user_tab_columns where table_name =
'PS_TL_RPTD_TIME'; DATA_TYPE
NUMBER
DATE
VARCHAR2
Received on Mon Nov 27 2006 - 06:54:54 CST