Monday, November 14, 2016

Performance Monitoring through OS Commands

S/N
Steps
Command
Remarks/Cautions
1.
Login into server where you have to shutdown the database
Use putty to login into the server using user name

2.
To check overall server performance
1. Displays the per-second frequency of paging statistics.
2. Displays the real memory size and the distribution of memory in use.
3. Display size and utilization of paging space.
4. Display CPU utilization.
5. Displays a list of hot network interfaces
$ topas

3.
To check virtual memory activity

r
Number of kernel threads placed in run queue.


B
Number of kernel threads placed in wait queue (awaiting resource, awaiting input/output).

avm
Active virtual pages.

fre
Size of the free list.


Re
Pager input/output list.


pi
Pages paged in from paging space.


po
Pages paged out to paging space.


Fr
Pages freed (page replacement).


Sr
Pages scanned by page-replacement algorithm.


cy
Clock cycles by page-replacement algorithm.


In
Device interrupts.


sy
System calls.


cs
Kernel thread context switches.


us
User time.

sy
System time.

Id
CPU idle time.

wa
CPU idle time
$ vmstat 2 10

4.
To check high memory consuming processes
$ ps aux | head -1; ps aux | sort –rn +5 | head -20

5.
To check disk performance
$ iostat 2 10

6.
Complete server performance. Ask nmon output from AIX team. Use nmonanalyzer to analyze the nmon output. It will give complete OS performance statistics.


2 comments:

  1. great information thanks for sharing ,when u have time plz share this kind of Articals.Oracle R12 Financials Training in Hyderabad

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete