Re: Problem with some ORACLE.EXE (SHAD) processes
- From: David Ramírez Reyes <dramirezr@xxxxxxxxx>
- To: Maaz Anjum <maazanjum@xxxxxxxxx>
- Date: Wed, 25 Sep 2013 14:15:43 -0500
This is a new environment that was migrated from a very old 8i version just
a week ago; the problems started 2 days after the Go Live...
The EMC advisor says there's a big Virtual Memory paging (I changed the sga
max memory from 6.5 GB to 10 GB 5 days ago without any difference on cpu
usage), but I have other db's (also migrated from 8i) with much more
Virtual Memory usage without any cpu problems (for more than a year) with
the same hardware capabilities.
Performance in general is very good, the problem comes every 24-36 hours
when the cpu goes to the 100% pick and the service hungs; it has failed at
11 am, 5 pm, 7 am, etc, there's no pattern on the hours..
David Ramírez Reyes
Profesión: Padre de Familia
On 25 September 2013 13:18, Maaz Anjum <maazanjum@xxxxxxxxx> wrote:
> I am curious about the wait events you observe (or not) on the instance.
> My subsequent question would be (and you might have already asked): What
> changed in your environment in the last few days?
>
>
> On Wed, Sep 25, 2013 at 2:12 PM, David Ramírez Reyes
> <dramirezr@xxxxxxxxx>wrote:
>
>> By the way, there are no errors on the error log for the DB or listener.
>>
>> Regards
>>
>> David Ramírez Reyes
>> Profesión: Padre de Familia
>>
>>
>>
>> On 25 September 2013 13:07, David Ramírez Reyes <dramirezr@xxxxxxxxx>
>> 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.
>> >
>> > All this cpu is used by oracle.exe so, I dowloaded a tool to monitor the
>> > specific processes cpu usage at OS Level (MS Process Explorer) and I
>> notice
>> > 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)
>> >
>> > This is something strange because I have 3 similar instances on another
>> > server with exactly the same characteristics and I have no problem, even
>> > cpu usage goes between 10-20%.
>> >
>> > Does anybody has an idea of how to know which Oracle processes are
>> related
>> > to these (SHAD) processes?, I even stop the EMC for some time without
>> any
>> > difference.
>> >
>> > Thanks in advance.
>> >
>> >
>> > David Ramírez Reyes
>> > DBA
>> >
>> >
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> A life yet to be lived...
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
