Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time

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

From: <mccmx_at_hotmail.com>
Date: 27 Nov 2006 04:54:54 -0800
Message-ID: <1164630333.476569.135770@j44g2000cwa.googlegroups.com>


> "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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US