Re: sqllder hangs at 99-100% CPU on select of fet$

Additional information:

We are able to run other bulk-load sqlldr apps to load data into other tables in that same tablespace, so it is something specific to that table.

Don Seiler wrote:
> I made an earlier post but the info in that is incorrect and I can't
> wait for it to show up on usenet.
>
> Using Oracle 7.3.4.5 on HP-UX. I have an application that uses sqlldr
> to bulk load a table. The table usually has around 65 million rows.
> This application has worked fine in the past, but for some reason this
> week it isn't working. When the application is started, it might load
> some (once it got up to 90,000 records, now it does 0), but eventually
> it will hang, the oraclesid process for it will go to 99-100% CPU usage,
> and nothing will happen.
>
> I load up TOra to see what it is doing and this is the current SQL it
> shows me for that process:
>
> SELECT length
> FROM fet$
> WHERE file# = :1
> AND block# = :2
> AND ts# = :3
>
> I'm assuming that sqlldr does that on it's own because my developers
> have no idea what fet$ is. This process locks fet$ and eventually will
> block SMON from accessing the table. This whole mess makes the database
> unusable until I kill the sqlldr's oraclesid process.
>
> Any remedies would be welcomed with open arms.
>
Received on Tue Sep 09 2003 - 17:09:34 CDT