全部博文
-
编辑 删除
awr 计算
Snap Id Snap Time Sessions Curs/Sess--------- ------------------- -------- --------------------------Begin Snap: 13736 07-Sep-11 09:30:17 19 4.6End Snap: 13737 07-Sep-11 10:00:17 27 3.5Elapsed: 30.01 (mins)DB Time: 0.15 (mins)sessions:Select Value From dba_hist_sysstat Where snap_id=13736 And stat_name In ('logons current');cursors:Select Value From dba_hist_sysstat Where snap_id=13736 And stat_name In ('opened cursors current');DB Time:Select (x2.value-x1.value)/(1000000*60) "DB time"
