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
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
