Re: Problem with some ORACLE.EXE (SHAD) processes

From: Ingrid Voigt <GiantPanda_at_gmx.net>
Date: Wed, 25 Sep 2013 21:29:25 +0200
Message-ID: <52433995.6080505_at_gmx.net>

That was the sqlnet.ora on the client.
And btw, our system was Oracle 11.2.0.3 on Windows 2008 R2, too.

Regards
Ingrid

On 25.09.2013 21:16, David Ramírez Reyes wrote:
> Where did you configure that?, on the client or the listener?
>
> David Ramírez Reyes
> Profesión: Padre de Familia
>
>
>
> On 25 September 2013 14:01, Ingrid Voigt <GiantPanda_at_gmx.net
> <mailto:GiantPanda_at_gmx.net>> wrote:
>
> Hi,
>
> I have seen the exact same symptoms when an older client (Forms 6i)
> was trying to connect with SQLNET.AUTHENTICATION_SERVICES
> set to (NTS). Every attempted connection blocked a CPU core.
> The problem went away when using (NONE).
>
> (We never did proper troubleshooting to find the underlying cause,
> just compared with a working client.)
>
>
> Best regards
> Ingrid Voigt
>
>
>
>
> On 25.09.2013 20:07, David Ramírez Reyes wrote:
>
> Hi All,
> I have an Oracle 11g R2 over a windows server 2008 (am the first
> of hating
> Windows, but that's what I have...); it has 10 GB of SGA, 500
> process limit
> -400 processes avg-, db on archive mode.
>
> The server has 16 GB of physical memory and 8 cpu cores.
>
> Now the problem is this:
>
> On the last days, the cpu usage has been growing up about every
> 12-16
> hours, it starts at 8-10 avg, then goes to 28-35, then 65-75,
> 90-95 and
> then 100 pick, once it goes to 100% the db hungs (and the
> server itself
> hungs) and there's no other solution than restart the instance.
>
> that the heavy load of cpu usage is on 6 processes which are the
> following:
>
> SYSTEM 190 ORACLE.EXE (SHAD)
> SYSTEM 25 ORACLE.EXE (SHAD)
> SYSTEM 5 ORACLE.EXE (SHAD)
> SYSTEM 211 ORACLE.EXE (SHAD)
> SYSTEM 167 ORACLE.EXE (SHAD)
> SYSTEM 2 ORACLE.EXE (SHAD)
(cut a bit to avoid overquoting)

.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 25 2013 - 21:29:25 CEST