VMSTAT (virtual memory statistics) is a useful monitoring tool that also shows block IO and CPU activity in addition to memory use.
The average numbers since the previous time the machine was rebooted will appear on the first line of the report. The current values for all other lines in the report will be shown. Vmstat doesn't require any specific user permissions. It may be used as a regular user.
Use the iostat command to generate metrics of throughput, utilisation, queue lengths, transaction rates, and service time based on disc input and output data.
The statistics since the previous time the system was booted are displayed in the first line of output. The interval statistics are shown on each successive line. The default setting is for statistics to be displayed for the terminal (tty), disks (fd and sd), and CPU (cpu).
For further information on Oracle Database performance tuning, visit the link mentioned below:
Thank you :)
VMSTAT (virtual memory statistics) is a useful monitoring tool that also shows block IO and CPU activity in addition to memory use.
The average numbers since the previous time the machine was rebooted will appear on the first line of the report. The current values for all other lines in the report will be shown. Vmstat doesn't require any specific user permissions. It may be used as a regular user.
Use the iostat command to generate metrics of throughput, utilisation, queue lengths, transaction rates, and service time based on disc input and output data.
The statistics since the previous time the system was booted are displayed in the first line of output. The interval statistics are shown on each successive line. The default setting is for statistics to be displayed for the terminal (tty), disks (fd and sd), and CPU (cpu).
For further information on Oracle Database performance tuning, visit the link mentioned below:
https://www.support.dbagenesis.com/home/categories/performance-tuning