Average time between log switches on database
作者:redhill 时间:03-08-11 22:20
作者:snowhite2000 时间:03-08-12 00:22
作者: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