Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle is Spinning its Wheels

Oracle is Spinning its Wheels

From: Craig Kelley <ink_at_inconnu.isu.edu>
Date: Fri, 31 May 2002 16:11:13 -0700
Message-Id: <slrnafft80.u1o.ink@inconnu.isu.edu>


I'm running Oracle under RedHat 6.2, and it's been flawless, however just this week Oracle has started hanging up while using 100% of the CPU. The memory usage of that process gradually increases over time, but is still only using about 25MB after 8 hours of doing this.

It's Oracle 8.1.7.0.0 running on a Xeon/1Ghz machine with 1GB of RAM and about 200 GB of disk space. How do I diagnose the problem? I can still login to the server and execute simple queries, but if I do anything complicated (including a sort) then it'll sit there "forever" doing nothing at all. "dbshut" acts the same way, even if I tell it to perform an immediate shutdown, it'll sit there waiting for something. There is one error in the alert log:

Tue May 28 09:57:07 2002
Errors in file /u01/oracle/admin/dur/udump/ora_2410.trc: ORA-00600: internal error code, arguments: [723], [52680], [52680], [memory leak], [], [], [], []

Any advice?

-- 
Craig Kelley  -- kellcrai_at_isu.edu  -- This document is rot26-encoded, and 
protected from being read by the DMCA and all other WIPO treaty nations.
http://www.isu.edu/~kellcrai finger ink@inconnu.isu.edu for PGP block
Received on Fri May 31 2002 - 18:11:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US