转换前
1 2012/5/9 18:05:00 user calls 4481094955
2 2012/5/9 18:05:00 session logical reads 1656238983063 2012/5/9 18:05:00 physical reads 915988333
4 2012/5/9 18:05:00 db block changes 3333311596
5 2012/5/9 18:05:00 physical writes 233762110
6 2012/5/9 18:05:00 redo size 1063096748164
7 2012/5/9 18:05:00 parse count (total) 1580843357
8 2012/5/9 18:05:00 parse count (hard) 6891819
转换后
159 2012/5/8 16:58:51 3167451226 128013490876 676410188 2483077920 174169593 841317673508 1111692633 4710091
68 2012/5/8 17:47:45 3410688202 209702005301 379979983 1835743794 88338634 308914953788 1300143362 11272530
36 2012/5/9 0:01:00 3755268810 214491887556 417978165 2106035279 108704311 397443352332 1424450058 11653136
58 2012/5/9 15:41:49 4262641942 158660533823 880363706 3174013405 224635956 1027439854752 1498550228 6337554
182 2012/5/9 17:22:10 4424440611 164044637886 906353883 3299203346 231397516 1054156491932 1560166015 6808871
59 2012/5/9 17:30:00 4436524811 164417347282 908040863 3305849249 231852152 1055959722168 1564884556 6828894
133 2012/5/9 17:35:00 4443757948 164643839620 909024377 3309703205 232185078 1057017191012 1567529927 6844368
134 2012/5/9 17:40:00 4450598645 164847175202 910455113 3313401634 232472114 1058080471408 1570014231 6856494
160 2012/5/9 17:45:00 4457087531 165049361752 911857975 3320908480 232720080 1059416170012 1572347387 6866855
106 2012/5/9 17:50:00 4463270783 165206210394 913404395 3324278125 233038347 1060388895992 1574515341 6875460
126 2012/5/9 17:55:00 4469296980 165347915631 914491570 3327334292 233281575 1061299401796 1576667543 6881072
代码:
select insert_time,
sum(decode (name,'user calls',value,null))"user calls",
sum(decode (name,'session logical reads',value,null))"session logical reads",
sum(decode (name,'physical reads',value,null))"physical reads",
sum(decode (name,'db block changes',value,null))"db block changes",
sum(decode (name,'physical writes',value,null))"physical writes",
sum(decode (name,'redo size',value,null))"redo size",
sum(decode (name,'parse count (total)',value,null))"parse count (total)",
sum(decode (name,'parse count (hard)',value,null))"parse count (hard)"
from ak_db_stats
group by insert_time