XOS agent configuration

To additionally monitor the resources of the database server, run a separate XOS agent process on the database server to collect data.

Note

• It can be applied to only the OS environment running on the x86 architecture.

• For more information about the XOS agent installation, see the following.

Configuring the whatap.conf file

Set the following options in the whatap.conf file before running the XOS agent.

• xos Int

  Default 0

  Set whether or not to use the XOS agent. If the value is 0 the XOS agent is not used for collection. Enter the value as 1 or IP address of the XOS agent. If the IP address is specified, data is collected from only the XOS agent.

• xos_port String

  Default 3002

  Set the port to communicate with the XOS agent. XOS agent can be communicated via UDP. If you have set a firewall on that port, disable it for UDP communication.

• xos_cpu_iowait Int

  Default 1

  Set whether the CPU utilization collected from the XOS agent is to include the iowait value. If the value is set to 1, the iowait value is included. If set to 0, the value is not included.

• xos_mem_buffcache Int

  Default 0

  Set whether the memory utilization collected from the XOS agent is to include the buffcache value. If the value is set to 1, the buffcache value is included. If set to 0, the value is not included.

Configuring the xos.conf file

Copy the xos directory to the database server, and then enter the agent server information and set additional options in the xos.conf file.

• dbx_ip String

  Enter the IP address of the server in which the DBX agent has been installed.

• dbx_port String

  Default 3002

  Set the port to communicate with the DBX agent. DBX agent can be communicated via UDP. If you have set a firewall on that port, disable it for UDP communication.

• cpu_limit Int

  Default 0

  It collects the process data with a value greater than the set limit. If it is 1.23% (1/100% step), set it to 123.

• mem_limit Int

  Default 10240

  It collects the process data with a value greater than the set limit. 10240 (Kbytes) indicates 10 MB.

• disk_usage_interval Second

  Default 60

  It displays the disk utilization, free sizes, and total sizes for each instance. If the value is 0, the disk utilization is not collected.

• port_check String

  The XOS agent attempts to connect directly to the port specified as an option. If it fails, the port list is sent to the db_port_check category.

  xos.conf

  port_check=192.168.122.113:3333,192.168.122.113:3334

  If access cannot be made via the specified port, you can check it after selecting the db_port_check category in Analysis > Metrics Search.

  

• process_check String

  You can monitor the running status of processes. Enter the process name as an option. You can register multiple items using comma (,) as the delimiter.

  xos.conf

  process_check=pmon,smon,tnslsnr,melong,haha

  When the process containing the string is not monitored, the data is sent to the db_process_check category. For example, if there have no melong and haha processes, you can check it after selecting the db_process_check category from the Analysis > Metrics Search menu.

  

  Note

  You can use the process_check option to send an alert when a process running in the database ends. For more information, see the following.

• process_check_interval Second

  Default 6

  The process_check option sets the time interval for collecting the process execution status.

• iplist_interval Second

  Default 0 (Off)

  Set the time interval for collecting the IP list for the database server. You can set the time interval in seconds (minimum of 3 seconds).

  Note

  If the xos_dbip=true option is set in the whatap.conf file, it is sent to the db_ip_list category. You can check it after selecting the db_ip_list category from the Analysis > Metrics Search menu.

• file String

  To use the Log menus (Live Tail, Log Trend, Log Search, Log Configuration), enter the absolute path in the file option for the log files to be monitored.

  xos.conf

  file=/home/oracle/diag/rdbms/ora18/ORA18/trace/alert_ORA18.log

  Tip

  To add a logfile to monitor, add options in the same way as file, file1, file2.

  xos.conf

  file={log_file_path1}
  file1={log_file_path2}
  file2={log_file_path3}
  file3={log_file_path4}

User Metric Collection (SHMON)

SHMON periodically collects the results of user-defined shell scripts and stores them as metrics.

• shmon Int

  Default value: 1

  Supported version: dbx 2.55.01 or later & xos 1.2.0f or later

Configuration

1. Create a shmon directory in the agent installation path.
2. Save the script to be collected as a .sh file.
3. Enable SHMON in xos.conf.
4. Restart the agent.
5. In the Sitemap > Metrics Search menu, check the shmon category.

# xos.conf
shmon=1

Note

• The file option is available in DBX Agent 1.9.0 or later.

• For more information about the Log menus, see the following.

Running the XOS agent

Run the following batch file on the database server.

$ ./start.sh

# or

$ ./startd.sh # When running in the background