Re: sqlldr locks fet$ and uet$, blocks smon, 100% cpu usage

On Wed, 10 Sep 2003 10:48:19 +1000, Howard J. Rogers wrote:

> If your table definition read:
>
> COL1 varchar2(4000)
> COL2 varchar2(4000)
> COL3 varchar2(4000)
>
> ....then it is still almost certain to be row chaining, and not migration.
> It's the row length that's the issue, not just whether there are LONGs
> and/or LONG RAWs present.

No this table is mostly 16 or 8 varchar2 or number fields. I added all of them up and it totalled 324. The pctfree value is currently 10. How much larger should I make this? Received on Wed Sep 10 2003 - 09:00:55 CDT