Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to view the switching frequency of Oracle's redo log, which is very detailed and has a certain reference value. Interested friends must finish reading it!

Check the redo log switching frequency of Oracle

Two sql, the principle is the same, the second one uses a statistical function.

Unit of time: minutes

Method 1.

Select * from v$log a where a.THREAD# = 1

Set line 200

Select b.SEQUENCETIME, b.FIRSTUENCETIMErect a.SEQUENCETIME where a.SEQUENCE#=b.SEQUENCE#+1 and b.THREAD#=1 order by a.SEQUENCE# desc a.FIRSTUENCETIMEparting round (a.FIRST_TIME-b.FIRST_TIME) * 24) * 60 (2) from v$log_history a, v$log_history b TIME2)

Method 2.

Set line 200

Select sequence#,first_time,nexttime,round (first_time-nexttime) * 24) * 60Magne2) diff from (select sequence#,first_time,lag (first_time) over (order by sequence#) nexttime from v$log_history where thread#=1) order by sequence# desc

The above is all the contents of the article "how to view the redo log switching frequency of Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.