RE: TNS Ping Response spike during high cpu spikes

            I have the same issue. It happens when a batch job kicks in. They need another index on the table, but refuse to put it there and I am not allowed to. They are doing full table scans of a 100 gig table. Your first task is to figure out what is happening when you get the alert. Look for a pattern, then you know what to look at. Throwing hardware at a problem only works for so long. Fixing the code always works.

Liz
Long Suffering DBA

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, November 22, 2016 8:27 PM To: Jeff C
Cc: oracle-l_at_freelists.org
Subject: Re: TNS Ping Response spike during high cpu spikes

On Thu, Nov 17, 2016 at 1:21 PM, Jeff Chirco <backseatdba_at_gmail.com<mailto:backseatdba_at_gmail.com>> wrote: Lately I have been getting critical TNS Ping Response Time alerts from EM 12.1.0.5. The threshold is set to default of 1000ms. I have been noticing that I usually get them when the CPU on the server spikes 100% which makes since, if the CPU is busy then it can't respond as fast. Other than getting additional cpu power is there anything else I can do?

Hi Jeff,

In all sincerity, if it is not possible to add CPU, and not possible to reduce resource consumption, it seems there is little left to do than raise the threshold.

That said, were it me, I would investigate what is causing these CPU spikes.

Usually such things can be corrected, but determining why they happen is at least half the battle.

EE 11.2.0.4 on Windows 2008 R2 64bit
Listener serves up 5 databases.
EM stats show listener is processing 142 connections per minute but when I query the listener log I am seeing 225 entries in one minute, or 178 with a command of "establish". Not sure what the difference is.

Is this related to the previous question on CPU spikes?

Please take a few moments to consider it from the perspective of someone that knows little about the system in question (that would be us, on this list) and try to explain what is happening.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.pythian.com_blog_author_still_&d=DQMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=a3IkodtD5ktrVLT7qh_NbFwSgIGHmgbhrOd91_1yMpE&s=umJAEvUJn-E2_exPZRY6TeDRfK67FZWZqWhkqDGskuU&e=>

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