Common Oracle monitoring tools

The following articles collect some common Oracle monitoring tools in Linux operating systems. The following articles mainly describe how to correctly use these tools to apply them, the following is a detailed description of the related tools. I hope this will help you in your future studies.

1. top

The top command displays the process, CPU, memory, load, and other information of the Linux system in real time. It is the best tool for us to understand the overall state of the system.

The running status of the top Command is a real-time display process. On this page, we can monitor the running status of the system in Oracle. We can use several buttons to control the top Command, such as pressing q to exit the top command status, and pressing s to update the information. These commands can be queried by pressing the h help key.

2. Ps

The ps command can query the Process status. The common command parameter is ps-aux. This command can display the processes of all users. If the process command is too long, the displayed process information is incomplete. We can use the ps-auxw command to lengthen the display. The w parameter can be added a few more, up to three can be added to display longer process information.

3. Kill

The kill command can terminate the process and then connect the process number.

4. Free

Free displays the memory usage of the system. -B,-k, and-m parameters indicate memory usage in bytes, kilobytes, and megabytes.

5. Vmstat

Run the vmstat 2 command to display a line of system information every two seconds, including CPU usage, memory usage, and disk IO. With it, we can monitor the resource usage of the system in real time and optimize the system.

6. sar

The sar tool can help us collect dynamic system information. It has rich parameters and powerful functions. The sar tool periodically and quantitatively outputs system status information through counters and counting intervals.

7. watch

The watch command can be used to repeatedly execute a command. Oracle monitors the command execution status. The following command allows Oracle to monitor the size change of Z2.log files.

Debian :~ # Watch-n 3 du/home/Jims/zope/log/Z2.log

-N 3 indicates that du/home/Jims/zope/log/Z2.log is executed every three seconds.

8. Sysctl

Use sysctl-a to display all running kernel parameters, and use sysctl-w fs. file-max = 10240 command can be modified fs. file-max Kernel Parameter Value, and make the parameter take effect immediately. However, after the system is restarted, the parameter settings will expire, because the command line can only modify the running kernel parameters. If you want to fix the parameters, you can write the kernel parameters to the/etc/sysctl. conf file. The file format is as follows:

 
 

  
  
# /etc/sysctl.conf - Configuration file for setting system variables  
  
  
# See sysctl.conf (5) for information.  
  
  
# Controls IP packet forwarding  
  
  
net.ipv4.ip_forward = 0 
  
  
# Controls source route verification  
  
  
net.ipv4.conf.default.rp_filter = 1 
  
  
# Controls the System Request debugging functionality of the kernel  
  
  
kernel.sysrq = 0 
  
  
# Controls whether core dumps will append the PID to the core filename.  
  
  
# Useful for debugging multi-threaded applications.  
  
  
kernel.core_uses_pid = 1 
 
 

9. Ulimit

Use ulimit-a to display system resource limits.

10. Netstat

Netstat-nal displays all network connections.

11. Pppstat

You can use pppstats to obtain the status information of the ppp connection.
 

The above content is an introduction to some common Oracle monitoring tools in the Linux operating system.

Article by: http://database.csdn.net/page/c5f86588-ac33-4986-a702-b14a01ff3f77