Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Recent Posts

Thursday, February 27, 2014

HowTo: Read ST03 IO Redo Log Per Hour, Log Switches in SAP

Print Friendly and PDF
Within the SAP St03 transaction, the analysis view "Wait Event Analysis -> IO Redo Log Per Hour" or "Redo Log Switches" (from SAPKB70029 onwards), is able to show you the Oracle redo log switch measure.
SAP Oracle IO Redo Log Per Hour
You will need to adjust the "Minimum Time Between Switches[sec]" and "Maximum Time Between Switches [sec]" values, then click the refresh button.
The results tell you in what hour period, the number of times a redo log switch was performed where the time between the switches was within your defined range.
As an example, the screen shot above shows that on 29-11-2013 between 04:00 and 05:00, a redo log switch occurred on only 1 occasion where the time between one log switch and another was within 120 seconds (2 minutes).
It's difficult to say if too many log switches is an actual problem for your specific database, but I would tend to investigate any database where the logs are switching on more than a couple of occasions a day, within 60 seconds.

2 comments:

Anonymous said...

I think this tx is T04

Darryl Griffiths said...

I think you're right.
I've put ST03 instead of ST04. But I seem to remember this also displays on the left hand menu of DB02 (DBACOCKPIT) when on Oracle.

Darryl