摘要:
SELECTTO_CHAR(first_time,'MM/DD') DAY--, TO_CHAR(first_time,'YYYY/MM/DD') DAY2, SUM(DECODE(TO_CHAR(first_time, 'HH24'),'00',1,0)) H00, SUM(DECODE(TO_CHAR(first_time, 'HH24'),'01',1,0)) H01, SUM(DECODE... 阅读全文
摘要:
select name, value from v$sysstat where name in ('table scans (short tables)', 'table scans (long tables)', 'index fast full scans (full)', 'index fast full scans (rowid ranges)',... 阅读全文