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 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b) Gecko/20030827 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: sqllder hangs at 99-100% CPU on select of fet$ References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 35 Message-ID: NNTP-Posting-Host: 67.39.35.90 X-Complaints-To: abuse@prodigy.net X-Trace: newssrv26.news.prodigy.com 1063145374 ST000 67.39.35.90 (Tue, 09 Sep 2003 18:09:34 EDT) NNTP-Posting-Date: Tue, 09 Sep 2003 18:09:34 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: [[PAPDCAO@W[S_\YGBHNO_\K@CVDB\XILA]T]_MIJQR@EPIB_VUKAH_[MTX\IS[K[NGYJJFNOFZR_G[BUNTAOQLFE^TEHRPI]PZZRP_BMDSFQFL_]CBHXRWCMDCUZAZN@D_AKMNLEI]MWHCSXL^]NNC__CZFGSGHYYXWPFG@SCAVA]\FT\@B\RDGENSUQS^M Date: Tue, 09 Sep 2003 22:09:34 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242733 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. >