log_switch
emcs
50次下载
551次浏览
2019-07-24
4.5

脚本内容

col LOG_HOUR format a12 select to_char(first_time,'YYYY-mm-dd') LOG_DATE, to_char(first_time,'HH24') LOG_HOUR, count(*) SWITCHES from v$loghist group by to_char(first_time,'YYYY-mm-dd') , to_char(first_time,'HH24') order by 1,2;

评论

贡献排行榜