Re: TNS Ping Response spike during high cpu spikes
- From: Jared Still <jkstill@xxxxxxxxx>
- To: "Reen, Elizabeth" <elizabeth.reen@xxxxxxxx>
- Date: Sun, 27 Nov 2016 10:58:43 -0800
On Wed, Nov 23, 2016 at 7:13 AM, Reen, Elizabeth <elizabeth.reen@xxxxxxxx>
wrote:
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.
In this situation the solution is simple from the DBA point of view;
instructing the monitoring SW to ignore this alert if at all possible.
I sometimes have difficulty understanding why some folks would prefer to
let there database be slow and struggle with what should be a
straightforward query.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog
http://www.pythian.com/blog/author/still/
Other related posts: