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

From: David Ramírez Reyes <dramirezr_at_gmail.com>
Date: Mon, 30 Sep 2013 10:59:41 -0500
Message-ID: <CAJt=wvVcpw9Rvj_AWCirpg==7=r23QY133wf1DuKQXmX-Ofbeg_at_mail.gmail.com>

Thanks to all (specially Ingrid) for your suggestions and help, the problem were caused by some machines that had the 8 client (there was one with even 7 client); now cpu average is 1.5 - 2.5% on pic hours. Regards

David Ramírez Reyes
Profesión: Padre de Familia

On 26 September 2013 11:26, Andy Klock <andy_at_oracledepot.com> wrote:

> Some days, my fingers can't distinguish CTRL-S from CTRL-V...
>
> As I was saying...
>
> Tanel's sw.sql is very slick:
>
> http://blog.tanelpoder.com/files/scripts/sw.sql
>
> and the info in here:
> http://blog.tanelpoder.com/2008/08/07/the-simplest-query-for-checking-whats-happening-in-a-database/
>
> and Snapper too. http://blog.tanelpoder.com/files/scripts/snapper.sql once
> you know the SIDs in question.
>
> Good luck.
>
>
>
> On Thu, Sep 26, 2013 at 12:23 PM, Andy Klock <andy_at_oracledepot.com> wrote:
>
>> Have you tried determining what those processes that you found with MS
>> Process Explorer are actually doing? I would start with Tanel's sw.sql:
>>
>>
>>

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

Received on Mon Sep 30 2013 - 17:59:41 CEST