Average Time Between Log Switches on Database

zhaozj2021-02-16  70

Average Time Between Log Switches on Database

Author: redhill

Time: 03-08-11 22:20

Average Time Between Log Switches on Database

What tool can you get how long the database last time log switches once a certain period of time? Thank you.

Could you please tell me How can I find the SQL Scripts to Calculate The average Time Between Log Switches Using V $ log_history? Thank you very much for your help.

Author: snowhite2000

Time: 03-08-12 00:22

One day twenty-four hours, take 60 minutes, except for the number of LOG generated, is it the average of you? Minute units. SQL> SELECT 24 * 60 / count (first_time) from V $ log_history where first_time limited '% 08-aug-03%; 24 * 60 / count (first_time) -------------- --------- 180

转载请注明原文地址:https://www.9cbs.com/read-16651.html

New Post(0)