RE: Windows & Oracle Issue

From: Jithin Sarath <jithinsarath_at_gmail.com>
Date: Wed, 30 Mar 2016 11:05:28 +0530
Message-ID: <CACoevcokoUq+3=4Wi24-31CD4PD=N7-fhwsBfLMDZizThdMDGQ_at_mail.gmail.com>

I would also suggest that if you suspect resource contention, the setup a perfmon counter to keep an eye on the usage. You can then correlate the crashes with dips/surges in the perfmon output.

If you have never done perfmon before, please do read a bit as wrongly configured it has the potential to fill up the disk pretty quick,and by default it will write to your systemdrive.

Regards, Jithin
On 30-Mar-2016 8:20 AM, "Kellyn Pot'Vin-Gorman" <dbakevlar_at_gmail.com> wrote:

> Windows resource issues are trapped in the event logs. Please inspect
> the Event Ciewer under the System Tab for the time of the outage and it
> should correspond with the application log that trapped the Oracle Service
> daemon going down.
>
> Kellyn
> On Mar 29, 2016 8:19 PM, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com>
> wrote:
>
>> I would suspect that you are running out of Memory and CPU resources.
>>
>>
>>
>> Hemant K Chitale
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Balwanth Bobilli
>> *Sent:* Wednesday, March 30, 2016 2:17 AM
>> *To:* oracle-l_at_freelists.org
>> *Subject:* Windows & Oracle Issue
>>
>>
>>
>> Product Oracle Database - Enterprise Edition
>>
>> Product Version:12.1.0.2
>>
>> Operating System :Microsoft Windows x64 (64-bit)
>>
>> OS Version: 2012 R2
>>
>>
>>
>> There are 80 SIDS sitting in one server and each as their own listener..
>> Same setup in built in multiple servers… Random Databases go down without
>> knowledge, All we need to do is restart the database and then it behaves
>> well. It is production box and happening frequently…Moreover, there are
>> only three windows scheduler jobs and we do not see any failure in it and
>> those are small scripts.. Tail of the alert log of one DB, Can anyone say
>> me how to find the root cause? It will be really helpful
>>
>>
>>
>>
>>
>> Suspending MMON action 'CLI AutoPartition' for 82800 seconds
>> Mon Mar 28 07:47:30 2016
>> Suspending MMON action 'tablespace alert monitor' for 82800 seconds
>> Mon Mar 28 07:53:00 2016
>> Suspending MMON action 'Cleanup of unpinned KGL handles' for 82800
>> seconds
>> Mon Mar 28 07:58:37 2016
>> Suspending MMON action 'flushing workload information for optimizer' for
>> 82800 seconds
>> Mon Mar 28 08:04:10 2016
>> Suspending MMON action 'KSXM Advance DML Frequencies' for 82800 seconds
>> Mon Mar 28 08:24:20 2016
>> Suspending MMON action 'undo usage' for 82800 seconds
>> Mon Mar 28 09:45:40 2016
>> Suspending MMON action 'autotask status check' for 82800 seconds
>> Mon Mar 28 11:27:23 2016
>> Starting ORACLE instance (normal) (OS id: 90240)
>> Mon Mar 28 11:27:23 2016
>> CLI notifier numLatches:131 maxDescs:5068
>> Mon Mar 28 11:27:23 2016
>> Specified value of sga_max_size is too small, bumping to 3992977408
>> SGA Local memory support enabled
>> LICENSE_MAX_SESSION = 0
>>
>>
>>
>> Thanks,
>>
>> Balwanth(Bob)
>>
>> Oracle Database Administrator
>>
>> [image: 1]
>>
>> Balwanth.bobilli_at_rackspace.com
>>
>> 1-512-874-1764
>>
>>
>>
>> This email and any attachments are confidential and may also be
>> privileged. If you are not the intended recipient, please delete all copies
>> and notify the sender immediately. You may wish to refer to the
>> incorporation details of Standard Chartered PLC, Standard Chartered Bank
>> and their subsidiaries at
>> https://www.sc.com/en/incorporation-details.html
>>
>

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

Received on Wed Mar 30 2016 - 07:35:28 CEST