Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Tue, 09 Sep 2003 20:37:36 -0500
Message-ID: <3F5E7DF8.8060801@comcast.net>
Date: Tue, 09 Sep 2003 19:27:20 -0600
From: Ron Reidy <r_reidy@comcast.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
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: <f6r7b.487$ev2.331412@newssrv26.news.prodigy.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 37
NNTP-Posting-Host: 12.208.239.34
X-Trace: sv3-5ULjk+ZWhxRSsFA1k6pzHnOlUtfmeA/Z1gNxLPant8JCEXZiKyJJ3CpaJSzgkzvJZ6GyVUNg8AFGKp3!L06TR3gL6e5bpiK22SRkEs21ZDphPXFk3W5/KilgVsb2MnR2luLRbQ==
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242755

Did you run a trace using 10046?  If not, you can only guess at what is 
going on.

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.
> 


-- 
Ron Reidy
Oracle DBA