sqlldr locks up fet$, uet$, spins to 100% cpu

From: Don Seiler <don_at_seiler.us>
Date: Wed, 10 Sep 2003 00:35:27 GMT
Message-ID: <pan.2003.09.09.17.17.54.566889@seiler.us>

I'm having an issue with a process that has been running fine for some time now. This past week this sqlldr process puts locks on the fet$ and uet$ tables. This process gets stalled somewhere, and so those locks are blocking the smon process.

Somewhere in this quicksand there is an oracle<sid> process that takes up 100% of a CPU.

I know I have over 2 GB left in the affected tablespace.

Like I said, this process has been running fine for over a year now. Is there something else filled up that I should be doing routine maintenance on? Received on Tue Sep 09 2003 - 19:35:27 CDT