Average time between log switches on database

Average time between log switches on database

---

作者：redhill    时间：03-08-11 22:20

Average time between log switches on database

请问用什么工具可以得到在某一段时间内数据库多长时间log switches 一次的平均值？

谢谢。

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.

---

作者：snowhite2000    时间：03-08-12 00:22

一天二十四小时，乘 60 分钟，除一天的 log 生成的数量，是你要的平均值么？分钟为单位。

SQL> select 24*60/count(first_time) from v$log_history where first_time like '%08-AUG-03%';

24*60/COUNT(FIRST_TIME)
-----------------------
180