raysuen
个人简介
一个不是很靠谱的DBA，一个不是很靠谱的系统工程师
文章分类
发布时间：2016-12-23 15:46:52
set linesize 500col group# for 999col mb for 999col member for a100col thread# for 999col archived for a10select a.group#,a.BYTES/1024/1024 mb,b.MEMBER,a.thread#,a.sequence#,a.members,a.archived,a.status,a.first_time,a.next_time from gv$log a,gv$logfile b where a.GROUP#=b.G.........【阅读全文】
阅读(98) | 评论(0) | 转发(0)
发布时间：2016-12-23 15:45:50
SELECT to_char(first_time,'YYYY-MM-DD') day, to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'999') "00", to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'999') "01", to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)).........【阅读全文】
阅读(98) | 评论(0) | 转发(0)
