Introduction to main Oracle monitoring tools in Linux

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. We can monitor the system running status on this interface. 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.

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.

Kill

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

Free

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

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 this feature, we can monitor system resource usage in real time and optimize the system.

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.

Watch

The watch command can repeatedly execute a command to monitor the command execution status. The following command allows us to monitor the size changes 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.

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 forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Controls the System Request debugging functionality of the kernelkernel.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

Ulimit

Use ulimit-a to display system resource limits.

Netstat

Netstat-nal displays all network connections.

Pppstat

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

1. Update Data in the connection view of Oracle
2. Oracle Data Dictionary usage
3. Troubleshooting of common Oracle Database Problems