v$sys_time_model的資料在重啟後會引復位

logjiang發表於2009-03-30

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

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/67798/viewspace-1019597/,如需轉載,請註明出處,否則將追究法律責任。

相關文章