Oracle

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 »