Oracle Database (All) : Archive Log Generation (Distribution - hourly/daily/size)

Oracle Database (All) : Archive Log Generation (Distribution - hourly/daily/size)

19c Vineet Sachdeva   May 17, 2020

In this blog I am going to cover on how to find out 

1. total number of archives generated per hour & per day 

2. The size of the archives MB/ hour & MB per day

 SQL Code to Run 

Output Sample for redo switches / hour

Redo Switches / hour /day

Redo Size / hour /day

The complete script can be download as a GIST from here 

DEVOPS - How to find out processes in 'D' state of uninterruptible sleep (High I/O Wait)

DEVOPS - How to find out processes in 'D' state of uninterruptible sleep (High I/O Wait)

Performance Tuning Vineet Sachdeva   May 06, 2020

IN this blog I am going to write on how to find out processes state and specially when there is high I/O wait on the system. 

The key is to list down the process which are in 'D' or 'S' state (primarily 'D').

Run below command to list processes in 'D' state. Replace '^D' with '^S' to get list of processes in S State.

Once you get the process you can do action on it 

 for x in `seq 1 1 10`; do ps -eo state,pid,cmd | grep "^D"; echo "----"; sleep 5; done