Oracle Query monitor
The Oracle Query monitor tracks and records server availability and response time of the database server. It also provides the flexibility to record the result of a user-defined query. BMC TrueSight Infrastructure Management Server or Infrastructure Management agent executes the SQL query for every poll cycle. The target machine must be running Oracle Server v.8 or later and uses port 1521. Ensure that this port is open for inbound traffic, if monitor sits outside the firewall. For detailed statistics, use Oracle Intelliscope monitor. Oracle Query monitor collects data from Oracle 8, 9i, 10g Release 1 and Release 2, and 11g.
Monitored attributes for Oracle Query monitors
The following table lists the monitored attributes of an Oracle Query Monitor:
Attribute | Description |
|---|---|
Availability (%) | Availability of the monitored database. If connection and data transfer are successful, the system returns 100%, otherwise it returns 0. |
Connect Time (ms) | Time required by the database server to process login requests. |
Response Time (ms) | Time required by the database server to execute a user-defined query (such as Select, Insert, Update) and respond. Response time includes time of login request (start) and time of response to query (end). |
Value (#) | Value returned as response after executing the user query. |
Oracle Query monitor configuration information
The following table describes the information required during configuration of the Oracle Query monitor.
Configuration information | Description |
|---|---|
Input fields on the Configuration tab | |
Instance Name | Specify a name for the monitor instance. This is displayed on folders, graphs, lists, etc. |
Tag | Specify a tag value to search or group the objects. You can enter multiple name-value pairs, text, or include both (name-value pair and text). This gives you the option to group objects in different forms. Click the + icon to select a default tag class. The Enter Tag Details screen opens. Select Tag Class from the drop-down list and enter a tag value. Click Add to append tag class and value. Click Finish.
|
Source Agent | Select the name or IP address of the BMC TrueSight Infrastructure Management Server or Infrastructure Management agent to host the new monitor instance. |
Target Device | Specify the name/IP address of the machine to monitor. Infrastructure Management recommends that the target device and the IP address of the device where the monitor is being created be the same. Specifying Host Name will not resolve to IP address and DNS lookup will be done in every statistics poll. |
Port | Specify the TCP Control port. Default port is 1521. |
Protocol | Specify the protocol for communicating with the database server. Default is TCP. |
SID | Specify the system identification (SID) corresponding to the instance. |
User Name | Specify the user name to access the database. Ensure that the user has appropriate access rights. |
Password | Specify the password corresponding to the user name. |
SQL Statement | Specify the query to execute on each poll. The query defines the SQL statement for monitor operations. This query should use a simple read-only SQL statement such as SELECT (example, select count (*) from dual) or UPDATE. Complex queries like Joins and PL/SQL are not supported. The monitor expects an integer value from this query, so it is best to cast the returned value as an integer using the COUNT statement. The maximum data value that can be stored for this monitor is 2^ 31-1. You can also specify a file, which contains the SQL query using the following syntax: file: <filepath> (example, file:c:\temp\test.sql in Windows or file:/tmp/test.sql in UNIX). |
System-populated fields | |
Monitor Version | Version of the installed Infrastructure Management monitor. |
Control tab | |
Collect Data | Select/clear check box to enable/disable data collection for the monitored component. By default, data collection is enabled (check box selected). |
Retry Count | Specify the number of consecutive unsuccessful attempts for recording Zero availability for the poll. Default is 3. |
Retry Delay | Specify the time interval between two consecutive attempts of a single poll. Default is 20 seconds. |
Statistics Poll Interval | Specify the time interval between two consecutive Statistical data polls. Default is 5 minutes. |
Statistics Poll Timeout | Specify the time-out period for each poll of statistical data. If no data is available at the end of this interval, system records Zero availability and proceeds with the next scheduled poll. Default is 20 seconds. |
Group tab | |
Group Membership | This enables you to add a device and its monitors to one or more groups. Optionally, you may associate the device with a group. A group is used to logically organize the devices and monitors by department, geographic area, or service. Assigning a device to a group also enables the system administrator to restrict or allow access to certain devices. To associate the device with a group, select the group name here. |
Additional configuration and setup issues
The following table presents details about additional configuration and setup issues for the Oracle Query monitor.
Issue | Details |
|---|---|
Skip validation | Monitors can be created even when the target application/device is not running. Agent must be upgraded to 7.1 for creation of monitor using skip validation. This monitor enables forceful creation when the monitored target is not reachable or specified inputs are wrong. Click Yes on the Skip Validation confirmation message to forcefully create a monitor. Clicking No will fail the monitor creation. Forcefully creating the monitor when target is not reachable or with invalid input(s) may cause Availability to be set to 0. |
Monitor configuration | No additional configuration requirements for this monitor. Maintain the default configuration of Infrastructure Management. |
External setup | No external setup requirements for this monitor. |
External dependencies | No external dependencies for this monitor. |
Infrastructure Management agent dependencies | Infrastructure Management agent installation on the monitored host is not mandatory. Monitor instance can be created on any Infrastructure Management agent. |
Oracle Query monitor thresholds
Absolute thresholds for Oracle Query monitor
Attribute | Severity | Duration (min) | Flag | Default Threshold | OutsideBaseline | Baseline Type |
|---|---|---|---|---|---|---|
Availability | Critical | 0 | Below | 100 | N | ALL |
Response Time | Minor | 15 | Above | 500 | Y | ALL |
Signature thresholds for Oracle Query monitor
Attribute | Severity | Duration (min) | Flag | Threshold | Sensitivity | Absolute Deviation | % Deviation | Suppress | Baseline Type |
|---|---|---|---|---|---|---|---|---|---|
Availability | Event Only | 30 | Above | 0 | 0 | 0 | 5 | 1 | Hourly |
Availability | Event Only | 30 | Below | 0 | 50 | 0 | 5 | 0 | Hourly |
Connect Time | Event Only | 30 | Below | 0 | 0 | 0 | 5 | 1 | Hourly |
Response Time | Event Only | 30 | Below | 0 | 0 | 0 | 5 | 1 | Hourly |
Response Time | Event Only | 15 | Above | 500 | 50 | 10 | 5 | 0 | Hourly |
Value | Event Only | 30 | Above | 0 | 0 | 0 | 5 | 1 | Hourly |
Value | Event Only | 30 | Below | 0 | 0 | 0 | 5 | 1 | Hourly |