每分钟处理业务笔数

alter session Enable parallel dml; --打开并发
Select /*+ parallel(a,12) */
 To_Char(Createtime, 'yyyymmddhh24mi'), Count(*)
From Hsc_Au_Compdetal a
Where a.Difftype = 'ROW_DIFF' And a.Createtime > To_Date('2012-09-19 00:00:00', 'yyyy-mm-dd hh24:mi:ss') And
                        a.Createtime < To_Date('2012-09-20 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
Group By To_Char(a.Createtime, 'yyyymmddhh24mi')
Order By To_Char(a.Createtime, 'yyyymmddhh24mi');
generic
447 Bytes
© oneai.eu.org
alter session Enable parallel dml; --打开并发

Select /*+ parallel(a,12) */
 To_Char(Createtime, 'yyyymmddhh24mi'), Count(*)
From Hsc_Au_Compdetal a
Where a.Difftype = 'ROW_DIFF' And a.Createtime > To_Date('2012-09-19 00:00:00', 'yyyy-mm-dd hh24:mi:ss') And
                        a.Createtime < To_Date('2012-09-20 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
Group By To_Char(a.Createtime, 'yyyymmddhh24mi')
Order By To_Char(a.Createtime, 'yyyymmddhh24mi');