摘要: declare @i int set @i=1 while @i<=10000 begin insert into zpb (RYBH,PIC) select rybh,pic from zpb where zybh = '1' set @i=@i+1 end GO 阅读全文
posted @ 2011-04-15 21:06 meetrice 阅读(383) 评论(0) 推荐(0)
摘要: 1.1.1.SQL ordered by Elapsed Time: 记录了执行总和时间的TOP SQL(请注意是监控范围内该SQL的执行时间总和,而不是单次SQL执行时间ElapsedTime= CPUTime+Wait Time)。 SQL ordered by Elapsed Time Resources reported for PL/SQL code includes the reso... 阅读全文
posted @ 2011-04-15 20:03 meetrice 阅读(536) 评论(0) 推荐(0)
摘要: http://hypercube1024.iteye.com/blog/767289 阅读全文
posted @ 2011-04-15 20:00 meetrice 阅读(458) 评论(0) 推荐(0)