MONITORING


2.1 Server

The following permissions must be configured on the monitored server to access it.

No Image

Server

This menu manages the servers you want to monitor. You can add, modify, or delete target servers.

No Image
  • ServerNo : This is the unique number of the server the product will automatically register with when the server registered. The value cannot be entered or modified. It only appears on the screen for reference.
  • Server ID : Provide the name for the server to monitor. When the system sends an alarm, it is sent with the name entered here.
  • Management ID : You can specify a group of configuration information for sending alarms from the product and give it to each server. By specifying the representative group configured in Monitoring > ServerMgmt for the monitoring server, you can specify the threshold information for the alarm to have and the level of the alarm that is generated, or the information to connect to the AWS at once.
  • If the administrator does not have a ServerMgmt setting, the DEFAULT value is automatically set as the default value.
  • Login ID : Enter User to connect to the Oracle Database. The user must have permissions.
  • Login Password : Enter password for the user. The password is saved and encrypted, and the screen displays the encrypted value.
  • IP Address : The IP address of the monitored server. The product and the monitored server and firewall must be open. Please check IP / Port for the firewall, and if the connection is not possible, the product does not perform monitoring.
  • Port : Port of the monitored server. This port refers to a TNS port.
  • Connection Type : There are two ways to connect with Oracle for monitoring. One can be connected by specifying a SID or by a Service Name.
  • Connection Name : If Connection Type is SID, enter the SID for Oracle. If Service Name is specified, enter Service Name.
  • CharSet : You can specify Oracle Charset. CharSet converts the format of the messages from Oracle to the specified CharSet and displays it on the product. If the values are different, some of the strings from Oracle Database appear corrupted.
  • Instance ID : If the product connects to the RDS on the AWS, the name of the instance specified on AWS. On AWS, the Instance ID is required for CloudWatch connections. However, it is not necessary to connect the products on-premises.
  • Yse YN : This feature allows you to stop monitoring the monitored server if you do not want to do so for a while, which corresponds to whether or not you are using it. When setting to 'N', the product does not collect any performance indicators on the monitored server. This feature can be useful for regular inspection or temporary power-off of the monitored server as known by the user.

2.2 ServerMgmt

Similar to User, the Server can be grouped by specifying the threshold value of the alarm for each group, or by setting whether to receive a message in Critical or Warning for an indicator without a threshold.

If the monitoring target uses Amazon's RDS service or is installed on EC2, you can easily specify and group AWS connection information and assign Management ID to each monitoring server for easy configuration.

No Image

Managing server groups

  • You can manage the Server Management Groups on the left side of the screen.
  • Management No : This is an group management number. This issue is a value that the product automatically gives, and user can see it on the screen for reference and cannot edit it.
  • Machine Type : You can select a total of 3 types. "NORMAL" is the type that you specify when monitoring Oracle installed on-premises. For On-premise, OS information cannot be retrieved because there is no special agent installed on the monitoring server. Only Database performance metrics are collected. For "AWS_RDS", select if the monitored server uses the Amazon RDS services. You can collect OS-related performance indicators in conjunction with Cloud Watch. Select "AWS_EC2" if Oracle is installed on Amazon EC2. As with RDS, it collects OS-related performance metrics. The reason for separating the product from RDS and EC2 is because the items collected from RDS and EC2 in Cloud Watch are different.
  • Descr : Enter the name of the relevant group. The "DEFAULT" group is automatically configured when the first product is installed.

Server Event Threshold

This menu setting is used when performance indicators are quantified and thresholds can be set. For example, "Active Session Count" refers to an indicator that can be quantified.

  • Click the Add button to add an indicator to the selected group on the left and enter the threshold information. The product sends an alarm to the user when the threshold value of the indicator reaches the configured threshold.
  • StatName : Indicates the name of the indicator. When an alarm occurs, the alarm is sent with this name.
  • Condition : User formula for whether the alarm should occur when it is greater than or equal to the configured threshold.
  • Warning : When the specified value is reached, an alarm is triggered with the name Warning.
  • Critical : When the specified value is reached, an alarm is triggered with the name Critical.
  • UseYN : It is a function that allows you to set a threshold and turn it off when needed. If the alarm is recognized by the user during system inspection or management, the alarm of the indicator can be manually turned off. When turned off, the product no longer checks the threshold value for alarm.

Server Event

  • Server event is an alarm like Oracle Alert log, but is configurable menu for alarm with description without digitized metrics.
  • Statname : Indicates the name of the indicator. When an alarm occurs, an alarm is sent with this name.
  • Event Level : When an alarm occurs, the name of the alarm level specified here is sent. If you set the Alertlog to Critical, it is sent Critical when an Alert Log Event occurs.
  • Use YN : If the alarm continues or the alarm is recognized by the user, the alarm function may not be used for a while.

2.3 Logging Info

The product is communicating Query-based with the monitored server. You can manage how often you receive results by sending Query for each function.

The shorter the performance data collection period, the more data you collect. Conversely, the longer the collection period, the less data you collect.

No Image No Image

2.4 StatName

You can manage all the indicators used by the product. The indicator types are as follows.

No Image

ORACLE_CUSTOM Stat

An indicator created separately by the product based on Oracle performance metrics. The formulas are as follows.

No Image

Product Event Stat

Manage alarm indicators generated by the product as separate indicators.

No Image

Oracle

No Image
  • stat_id : This is stat_id of Oracle. Same as stat_id on v$statname of Oracle. However, if Stat_type is a performance indicator made by the product, negative numbers are attached.
  • Stat Name : Displays the name of the metric. The name cannot be changed and is not visible on any screen in the product. The display name is used on the screen in the product, but only if there is no display name, the Stat name is displayed.
  • Class : Same class as v$statname. However, we use Category with this value in some parts of the product to help our understanding.
  • StatType : The product is separately classified by the characteristics of the indicator (see the table Statname).
  • Display Name : The product displays the name of the indicator as DisplayName on all screens. Use statname only if you do not have a Barman DisplayName.
  • Procession Type : Settings related to how performance indicators are processed after they are collected.
    • OFF : Do not collect performance data for these metrics
    • ON : The indicators collect performance data and use it on the real-time screen, and also use it on the analysis screen.
    • ON(Logging Only) : The indicators are not collected and used in real time, only on the analysis screen.
  • Display : Select whether the corresponding indicators are displayed as Sigma or Delta values on the screen. Use a lot of DELTA values except for most percentage indicators.

AWS

Only indicators collected by Cloud watch can be managed separately. The stat_id value starts with a negative number because it is not a default value from Oracle.

No Image
  • stat_id : AWS-only indicator. Specified as negative. Siat_id cannot be modified from the product. If a Cloudwatch indicator for Amazon AWS Service is updated in the future, it will also be added to EZIS.
  • Stat type : It has two Stat Types: AWS_EC2 and AWS_RDS, which are initialized in EC2 and RDS, predefined when installing the product, and cannot be modified by the user.
  • Stat Name : Displays the name of the metric. The name cannot be changed and is not visible on any screen in the product. The display name is used on the screen in the product, but only if there is no display name, the Stat name is displayed.
  • Display Name : The product displays the name of the indicator as DisplayName on all screens. Use statname only if you do not have a Barman DisplayName.
  • Maximum UseYN : Whether to collect Maximum values from CloudWatch.
  • Minimum UseYN : Whether to collect Minimum values from CloudWatch.
  • Average UseYN : Whether to collect Average values from CloudWatch.
  • Sum UseYN : Whether to collect Sum values from CloudWatch.
  • Samplecount UseYN : Whether to collect Samplecount values from CloudWatch.
  • Display : Whether the screen will show the value in Sigma or Delta.
  • Processingtype :
    • ON : Performance data of the corresponding indicators are collected and used on the real-time screen, and used on the analysis screen
    • ON(Logging Only) :The indicators are not collected and used in real time, only on the analysis screen.

2.5 Event

SendMethod Slack

Ezis can notify to you in several ways if an alarm occurs. In the current beta version, you can only set the shipment to Slack .

No Image
  • Method No : This is the unique number of Send Method that the product automatically manages. This number cannot be modified by the user.
  • Description : Give each individual name of the Send Method. Once the setup is complete and named, the UserMgmt menu allows you to determine the medium which receives the alarm.
  • Webhook url : Enter the webhook address for Slack.
  • Channel : Enter the channel name for Slack.
  • Timeout_sec_connect : Enter the connection value in seconds. It is recommended to set it up for at least 3 seconds in case the connection is delayed.
  • Timeout_sec_read : You can set a wait time when you receive a message, preferably for at least 3 seconds in case your response is delayed.
  • Type : Currently, beta version can be sent only as Slack, and alarms can be sent to various SNS in the future.
  • Group Message : Select whether to enable Group Message.
  • Use YN : You can disable this feature. If you type "N", the message will not be sent to SNS.
  • Last Modify Time : The time of the final modification of the setup information.

SendMessage Email

In this section you can send events to Email.

No Image
  • Description : Set name of each Send Method. Once the setting has completed and name has given, you could decide where to send a messege at UserMgmt menu.
  • Host : Write Email server host address here
  • Port : Write port number of the Host
  • Read Timeout : If you connect to a mail server and didn’t respond. After a few moments, it didn’t work anymore.
  • Connection Timeout : It is a waiting time to connect server. If this time has passed, it didn’t work anymore.
  • Group Message : Choose whether using group messege or not.
  • Auth id : Write down ID to access to mail server .
  • Auth Passwd : Password for accessing to Mail server.
  • From : Sender address
  • Subject : Subject of the mail that will be sent.
  • Use YN : You could stop the function that you selected. In case you select “N” message will not sent to M

Product Event

No Image
  • You can manage alarms generated by the product. Occurs when the product is accompanied by an unexpected error.
  • Users can receive messages by specifying the event level such as Critical or Warning depending on the importance of the corresponding indicator.
  • If you do not want to receive a message temporarily, set the UseYN value to "N" to stop the alarm.