Re: Problem with some ORACLE.EXE (SHAD) processes
- From: David Ramírez Reyes <dramirezr@xxxxxxxxx>
- To: Andy Klock <andy@xxxxxxxxxxxxxxx>
- Date: Mon, 30 Sep 2013 10:59:41 -0500
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> 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:
>>
>>
>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
