Depends on what you're really trying to find and which version you're on. "background checkpoints started" might be what you need. Regards Jonathan Lewis http://jonathanlewis.wordpress.com @jloracle ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf of Hameed, Amir [Amir.Hameed@xxxxxxxxx] Sent: 25 September 2014 17:24 To: oracle-l@xxxxxxxxxxxxx Subject: LGWR switching statistic Hi, Is there a database statistic available that can tell how many times LGWR switched redo log files? Thanks, Amir