select * from v$sys_time_model
重启前的记录值
STAT_ID STAT_NAME VALUE
3649082374 DB time 4729141726
2748282437 DB CPU 3391802159
4157170894 background elapsed time 7818674488
2451517896 background cpu time 281313392
4127043053 sequence load elapsed time 462268
1431595225 parse time elapsed 903621996
372226525 hard parse elapsed time 768313714
2821698184 sql execute elapsed time 4647568414
1990024365 connection management call elapsed time 36041693
1824284809 failed parse elapsed time 228118280
4125607023 failed parse (out of shared memory) elapsed time 0
3138706091 hard parse (sharing criteria) elapsed time 154356390
268357648 hard parse (bind mismatch) elapsed time 3407274
2643905994 PL/SQL execution elapsed time 1025390148
290749718 inbound PL/SQL rpc elapsed time 30742
1311180441 PL/SQL compilation elapsed time 35435340
751169994 Java execution elapsed time 17411070
1159091985 repeated bind elapsed time 8851766
2411117902 RMAN cpu time (backup/restore) 4001
重启后的记录值
3649082374 DB time 49970011
2748282437 DB CPU 20281257
4157170894 background elapsed time 19189794
2451517896 background cpu time 2972182
4127043053 sequence load elapsed time 5548
1431595225 parse time elapsed 19934492
372226525 hard parse elapsed time 19637423
2821698184 sql execute elapsed time 36943700
1990024365 connection management call elapsed time 491746
1824284809 failed parse elapsed time 509
4125607023 failed parse (out of shared memory) elapsed time 0
3138706091 hard parse (sharing criteria) elapsed time 32043
268357648 hard parse (bind mismatch) elapsed time 3703
2643905994 PL/SQL execution elapsed time 2369334
290749718 inbound PL/SQL rpc elapsed time 0
1311180441 PL/SQL compilation elapsed time 3055919
751169994 Java execution elapsed time 0
1159091985 repeated bind elapsed time 29417
2411117902 RMAN cpu time (backup/restore) 0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67798/viewspace-1019597/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/67798/viewspace-1019597/