Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssrv26.news.prodigy.com.POSTED!not-for-mail From: Don Seiler Subject: sqlldr locks up fet$, uet$, spins to 100% cpu User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) Message-ID: Newsgroups: comp.databases.oracle.server MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 13 NNTP-Posting-Host: 67.39.35.90 X-Complaints-To: abuse@prodigy.net X-Trace: newssrv26.news.prodigy.com 1063154127 ST000 67.39.35.90 (Tue, 09 Sep 2003 20:35:27 EDT) NNTP-Posting-Date: Tue, 09 Sep 2003 20:35:27 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: [[PA@SVEAZRYRRXXKROPZLPETSPNRRPIKYYDMREK@YWZUYUBK^RAAEW[QDZ\YQ_IT^C_[EVLDV^NOMOBFFTINWDGGFTKX_DHE@[DRVKC^DQPPOD^HKAHIP[CODFMKGJNYDYIZCZLPI_UWEGS@D^W^B_^J[Y^G\KHBYZC@ESAY[FDPVPEGDA^M]@D]VT_QQVL Date: Wed, 10 Sep 2003 00:35:27 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242748 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 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?