Re: Oracle is Spinning its Wheels

A quick check of Metalink (you did check Metalink - didn't you?) shows a PGA
memory link. They suggest setting an event to "safely" ignore small memory leaks.

jc
GetCertified! at http://www.networkessentials.com/certified/ocp Over 1,000 sample questions - Free!

"Craig Kelley" <ink_at_inconnu.isu.edu> wrote in message news:slrnafft80.u1o.ink_at_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?

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG