Re: Shared Server chewing up CPU

Sorry for the confusion. We have many Sun boxes and only a single Oracle instance on each; most are configured for Multi-Threaded Server. We have a mix of 8.1.7 and 8.1.7.1 throughout our shop.

The problem I described is happening on one of the 8.1.7 systems and on one of the 8.1.7.1 systems. These two happen to be the most heavily used systems. They are also configured for MTS (they are not the only ones, though).

To re-state the problem, every once in awhile we see a shared server process hang, utilizing 100% of a cpu. We've seen it on 8.1.7 and with the 8.1.7.1 patch applied so the patch doesn't help. The process hangs until we kill it.

Thanks,
Steve

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:<3B323057.FC72417B_at_attws.com>...
> Steve Croft wrote:
>
> > I am having a problem with shared servers in 8.1.7 and 8.1.7.1. A
> > shared server will sometimes start using up 100% of its CPU. It
> > continues until the shared server process is killed. Anyone see this
> > kind of behaviour or know if there is a patch?
> >
> > Our systems are Sun SPARC (some single- and multi-processor), Solaris
> > 8, and Oracle 8.1.7/8.1.7.1 - but we only see the problem on two of
> > the systems.
> >
> > Thanks!
> > Steve
>
> Are you saying that on a single server you are simultaneously running two
> different versions of Oracle against different instances?
>
> And if so ... why?
>
> Daniel A. Morgan
Received on Thu Jun 21 2001 - 17:00:52 CDT