CSDN博客

img snowhite2000

Average time between log switches on database

发表于2004/7/13 11:34:00  668人阅读

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

0 0

相关博文

我的热门文章

img
取 消
img