Re: Novell 4, Ora7, Net 1.1, Server hangs when a client disconnects

"Richard G. Ramirez" <ou79138_at_deere.com> wrote:

>A friend asked me to help with the following.
 

>When they are running a large load or update (10-15,000 rows)
>using SQL*Plus and the PC is disconnect for whatever reason,
>the Novell server reports 100% usage and stops all processing.
 

>Oracle support told them to study the basic concepts of rollback
>segments. I don't see the connection. They have many (10-13) rollback
>segments. The only strange thing is that several have 121 extents.
>I know this is the maximum but this problem is unrelated. I saw
>a case where SQL*PLUS displayed a message about being unable
>to extend the RBS and the server didn't hang up. They have a
>large RBS for large loads.
 

>They have one instance of Oracle 7.1 running on an almost dedicated
>Novell 4.1 server. SQL*Net is 1.1. The server also provides file
>and printing services which are essentially the files for Forms
>and Reports.
 

>Any ideas,
 

>Richard

Before troubleshooting any further please check that this server has applied the patches available in 410PT2.EXE. This set of patches has resolved many 4.1 related hangs/abends. To find the offending process try checking processor utilization, F3, will show all processes and their load %. If 410PT2.EXE doesn't clear the problem finding the processes hogging CPU time is a step in the right direction. Good Luck

James Grigolite...St. Bernard Software
www.stbernard.com
jgrigoli_at_stbern.mhs.compuserve.com Received on Tue Dec 26 1995 - 00:00:00 CET