Introduction to Oracle's main monitoring tools under Linux operating system

Oracle monitoring includes effective and complete monitoring of Oracle database performance, availability, and usage statistics, as well as immediate error notification and corrective actions, and provides comprehensive reports and graphs. This article mainly describes several Linux operating systems under the Oracle main monitoring tools.

Top

The top command displays real-time information about the Linux system's processes, CPU, memory, load, and so on. It is the best tool for us to understand the overall state of the system.

The run state of the top command is a real-time display that allows us to monitor the operation of the system at this interface. We can control the top command with a few keys, such as press Q to exit the top command state, press S to enter information update frequency, etc. These commands can be queried by pressing the H helper key.

Ps

The PS command can query the process state of the system, and the commonly used command parameters are Ps-aux, which displays the process of all users, and if the process's commands are too long, the displayed process information is not complete. We can use the PS-AUXW command to increase the length of the display, the W parameter may be added a few, up to three, to show longer process information.

Kill

The KILL command terminates the process, followed by the process number.

Free

Free Displays the memory usage of the system. The-B,-K,-m three parameters indicate that memory usage is displayed in Bytes,kilobytes and megabytes units.

Vmstat

Use the Vmstat 2 command to display one line of system information every 2 seconds, including CPU usage, memory usage, and disk IO. Through it we can monitor the resource usage of the system in real time, and optimize the system.

Sar

The SAR tool can help us collect dynamic system information, its parameters are very rich, powerful. The SAR tool is characterized by the periodic and quantitative output of system state information through counter and count intervals.

Watch

The watch command executes a command repeatedly to monitor the execution status of the command. The following command allows us to monitor the size change of the Z2.log file.

debian:~# Watch-n 3 Du/home/jims/zope/log/z2.log

-N 3 means that the Du/home/jims/zope/log/z2.log is executed every 3 seconds.

Sysctl

Use Sysctl-a to display all running kernel parameters, and use the Sysctl-w fs.file-max=10240 command to modify the values of the Fs.file-max kernel parameters and make the parameters effective immediately. However, after rebooting the system, the parameter settings are invalidated because the command line can only modify kernel parameters that are running. If we want to fix the parameter setting, we can write the kernel parameter to the/etc/sysctl.conf file. The format of the file is as follows:

#/etc/sysctl.conf-configuration file for setting system variables# see sysctl.conf (5) for information.# Controls IP PA Cket Forwardingnet.ipv4.ip_forward = 0# controls Source Route Verificationnet.ipv4.conf.default.rp_filter = # controls T He System Request debugging functionality of the KERNELKERNEL.SYSRQ = 0# Controls Whether core dumps would append the PID t o The core filename.# useful for debugging multi-threaded Applications.kernel.core_uses_pid = 1

Ulimit

Use Ulimit-a to display the system's resource limits.

Netstat

The netstat-nal can display all network connections.

Pppstat

Use Pppstats to get status information for PPP connections.