The pmap command can be used to obtain a memory map report for a process or list of processes. In my opinion, it is a great tool to explore memory leaks and any other memory related issues. If you simply invoke pmap with no options, it will list the usage with general available options, as shown …
iostat (input/output statistics) an utility that reports Central Processing Unit (CPU) statistics and input/output statistics for devices and partitions. The iostat command is used for monitoring system input/output device loading by observing the time the devices are active in relation to their average transfer rates. The iostat command generates reports that can be used to …
Analyzing Database Server I/O Bottlenecks using IOSTAT Read More »
ps (process statistics) is an utility that reports a snapshot of the current processes. By default, ps selects all processes with the same effective user ID (euid=EUID) as the current user and associated with the same terminal as the invoker. It displays the process ID (pid=PID), the terminal associated with the process (tname=TTY), the cumulated …
Identifying CPU and Memory Intensive processes on a database server using PS Read More »
mpstat (multiple processor statistics) is an utility that report processors related statistics. Below is the sample default output generated by mpstat with no options: The report generated by the mpstat command has the following format: CPU: Processor number, starts with 0. The keyword all indicates that statistics are calculated as averages among all processors. %user: …
Analyzing Database Server CPU/Processor Bottlenecks using MPSTAT Read More »
vmstat (virtual memory statistics) reports information about processes, memory, paging, block IO, traps, and cpu activity. Below is the sample default output generated by vmstat with no options: Column description of default output. Procs r: The number of processes waiting for run time. b: The number of processes in uninterruptible sleep. Memory swpd: the amount …
Analyzing Database Server Bottlenecks using VMSTAT Read More »