How to view the redo log group switching frequency of oracle

This article mainly introduces how to check the redo log group switching frequency of oracle, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

Check the redo log switching frequency of Oracle:

Unit: minutes

The first kind:

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)

The second kind:

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

Look at the size of your redo log.

The advice given by Oracle is generally about 15-20 minutes. To judge according to the amount of data, the maximum time (the minimum amount of data per unit time) should be maintained at 25-30 minutes, and it is best not to exceed 30 minutes. The shortest time (the largest amount of data per unit time), kept at more than 10 minutes.

SELECT trunc (first_time) "Date"

To_char (first_time, 'Dy') "Day"

Count (1) "Total"

SUM (decode (to_char (first_time, 'hh34'),' 001) "h0"

SUM (decode (to_char (first_time, 'hh34'),' 01) "H2"

SUM (decode (to_char (first_time, 'hh34'),' 02century record1, 0)) "h3"

SUM (decode (to_char (first_time, 'hh34'),' 03century record1, 0)) "h4"

SUM (decode (to_char (first_time, 'hh34'),' 04jewelry 1, 0)) "h5"

SUM (decode (to_char (first_time, 'hh34'),' 05pr 1 hh34') "h6"

SUM (decode (to_char (first_time, 'hh34'),' 06century, 1) "h7"

SUM (decode (to_char (first_time, 'hh34'),' 07 recording, 1) "h7"

SUM (decode (to_char (first_time, 'hh34'),' 08 girls, 1) "h8"

SUM (decode (to_char (first_time, 'hh34'),' 09 girls, 1) "h9"

SUM (decode (to_char (first_time, 'hh34'),' 10 years, 1) "H20"

SUM (decode (to_char (first_time, 'hh34'),' 11 girls, 1) "h21"

SUM (decode (to_char (first_time, 'hh34'),' 12 years, 1) "H22"

SUM (decode (to_char (first_time, 'hh34'),' 13 girls, 1) "H23"

SUM (decode (to_char (first_time, 'hh34'),' 14 girls, 1) "h24"

SUM (decode (to_char (first_time, 'hh34'),' 15 years 1) "h25"

SUM (decode (to_char (first_time, 'hh34'),' 16 years, 1) "h26"

SUM (decode (to_char (first_time, 'hh34'),' 17 girls, 1) "h27"

SUM (decode (to_char (first_time, 'hh34'),' 18 years, 1) "h28"

SUM (decode (to_char (first_time, 'hh34'),' 1913, 1) "h29"

SUM (decode (to_char (first_time, 'hh34'),' 20 million, 1) "H30"

SUM (decode (to_char (first_time, 'hh34'),' 21th record1) "H31"

SUM (decode (to_char (first_time, 'hh34'),' 22 million, 1) "H32"

SUM (decode (to_char (first_time, 'hh34'),' 23 million, 1) "h33"

FROM V$log_history

Group by trunc (first_time), to_char (first_time, 'Dy')

Order by 1

The above is all the contents of the article "how to View the redo Log Group 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!