Shulou(Shulou.com)06/01 Report--

This article introduces you how to use shell automation to diagnose performance problems, the content is very detailed, interested friends can refer to, hope to be helpful to you.

We have to do the automation of performance analysis for a long time, but I haven't started writing for a long time, so let's update it today.

First of all, one of the basic effects I hope to get is to scan the DB time of the database in the background. if the threshold is exceeded, for example, if I set it to 400 (that is, the DB time is 400%), the task of automatic diagnosis will be turned on. The time range is one hour in advance and the current time. I have made some changes to the existing script, added some logic, and will continue to improve.

DBTIME_THRESHOLD=400

DATE= `date'+% Y% m% d``

BEGIN_HOUR= `date-d "1 hour ago" + "% H" `

END_HOUR= `date + "% H" `

The following function gets the snapshot-level DB time situation

Function showsnap

{

Sqlplus-s $DB_CONN_STR@$SH_DB_SID

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.