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