PERFORMANCE BOTTLENECK CHECK USING OS TOOLS

A.REAL TIME PERFORMANCE TUNING USING OS TOOLS


TOOL1:-TOP UTILITY

check in TOP with column S where it shows ‘R’ means running and ‘S’ means sleeping.


TOOL 2:-SAR UTILITY WITH -U OPTION TO CHECK CPU AND IO BOTTLENECK
sar -u 10 8

TOOL 3:VMSTAT REPORT
vmstat 1 10
r column is runnable processes

TOOL 4:TO IDENTIFY DISK BOTTLENECK
sar -d 5 2

TOOL 5:-SAR -B TO REPORT DISK USAGE

TOOL 6:-SAR -Q TO FIND PROCESSES UNDER QUEUE.WE NEED TO LOOK BLOCKED SECTION

TOOL 7:-TO IDENTIFY MEMORY USAGE USING SAR -R


TOOL 8. REAL TIME PERFORMANCE TUNING USING ORATOP REPORT
./oratop -f -d -i 10 / as sysdba

How to get all the alert.log file entry for a date

grep -B1 -A1 'Jan 19' alert.log

awk '/Jan 19/{c=6}c&&c --' alert.log




Change Remote Window Password VPN via Mac

To Change Password on Window

Press fn-control-option-del

Extract range of lines from a text file in Unix

Input File    : orig-data-file
OutPut File : new-file

Line range 100 to 110

sed -n '100,110 p' orig-data-file > new-file

awk 'NR>=100&&NR<=110' orig-data-file > new-file

perl -ne 'print if 110..110' orin-data-file > new_file

-- get alert.log file for particular day
awk '/Jun 26/{c=6}c&&c --' alert_demo.log

grep -B1 -A1 'Jun 26' alert_demo.log




oratop

Pre- requisite

download oratop
set  oracle environment

helpful commands

oratop -i 5 / as sysdba



oratop -bdfi5 "/ as sysdba"



to remote database

oratop -f -i 5 sys/pass@db as sysdba

FOR HELP press h  and get the interactive key and enter in the main screen for example t is for table space