|
日期时间 存储过程 执行耗时(ms) 2003-10-15 13:56 dhsb_step 30 2003-10-15 13:57 dhsb_step 30 2003-10-15 13:57 dhsb_step 481 2003-10-15 14:00 dhsb_step 70 2003-10-15 14:00 dhsb_step 30 2003-10-15 14:00 dhsb_step 141 2003-10-15 14:01 dhsb_step 3926 2003-10-15 14:05 dhsb_step 4106 2003-10-15 14:05 dhsb_step 6690 2003-10-15 14:05 dhsb_step 6930 2003-10-15 14:06 dhsb_step 7091 2003-10-15 14:06 dhsb_step 60 2003-10-15 14:07 dhsb_step 121 2003-10-15 14:12 dhsb_step 40 2003-10-15 14:12 dhsb_step 40 2003-10-15 14:13 dhsb_step 100 2003-10-15 14:13 dhsb_step 250 2003-10-15 14:13 dhsb_step 40 2003-10-15 14:14 dhsb_step 30 2003-10-15 14:14 dhsb_step 150 2003-10-15 14:14 dhsb_step 40 2003-10-15 14:14 dhsb_step 40 2003-10-15 14:14 dhsb_step 110 2003-10-15 14:15 dhsb_step 15432 2003-10-15 14:15 dhsb_step 50 2003-10-15 14:16 dhsb_step 130 2003-10-15 14:16 dhsb_step 30 2003-10-15 14:16 dhsb_step 100 2003-10-15 14:17 dhsb_step 5078 2003-10-15 14:17 dhsb_step 60 2003-10-15 14:17 dhsb_step 100 2003-10-15 14:21 dhsb_step 40 2003-10-15 14:21 dhsb_step 160 2003-10-15 14:22 dhsb_step 30 2003-10-15 14:22 dhsb_step 12428 2003-10-15 14:22 dhsb_step 30 2003-10-15 14:22 dhsb_step 130 2003-10-15 14:23 dhsb_step 30 2003-10-15 14:23 dhsb_step 130 2003-10-15 14:23 dhsb_step 30 2003-10-15 14:23 dhsb_step 131 2003-10-15 14:23 dhsb_step 30 2003-10-15 14:24 dhsb_step 181 2003-10-15 14:24 dhsb_step 40 2003-10-15 14:24 dhsb_step 90 2003-10-15 14:24 dhsb_step 3966 2003-10-15 14:25 dhsb_step 40 2003-10-15 14:27 dhsb_step 30 2003-10-15 14:27 dhsb_step 30 2003-10-15 14:28 dhsb_step 40 2003-10-15 15:38 dhsb_step 40 2003-10-15 15:39 dhsb_step 40 2003-10-15 15:42 dhsb_step 30 2003-10-15 15:42 dhsb_step 300 2003-10-15 15:44 dhsb_step 30 2003-10-15 15:44 dhsb_step 141 2003-10-15 15:46 dhsb_step 30 2003-10-15 15:46 dhsb_step 30 2003-10-15 15:54 dhsb_step 40 2003-10-15 15:55 dhsb_step 30 2003-10-15 16:06 dhsb_step 30 2003-10-15 16:15 dhsb_step 4606 2003-10-15 16:25 dhsb_step 3755 2003-10-15 16:25 dhsb_step 221 2003-10-15 16:54 dhsb_step 631 2003-10-15 16:54 dhsb_step 30 2003-10-15 16:55 dhsb_step 40 2003-10-15 17:00 dhsb_step 41 2003-10-15 17:00 dhsb_step 851 2003-10-16 8:39 dhsb_step 3004 2003-10-16 8:39 dhsb_step 661 2003-10-16 9:28 dhsb_step 240 2003-10-16 9:29 dhsb_step 391 2003-10-16 9:29 dhsb_step 160 2003-10-16 9:29 dhsb_step 140 2003-10-16 9:30 dhsb_step 15873 2003-10-16 9:38 dhsb_step 31 2003-10-16 14:53 dhsb_step 9894 2003-10-16 14:53 dhsb_step 13509 2003-10-16 14:53 dhsb_step 11497 2003-10-16 14:54 dhsb_step 13329 2003-10-16 14:54 dhsb_step 7912 2003-10-16 14:56 dhsb_step 11467 2003-10-16 14:57 dhsb_step 9273 2003-10-16 15:15 dhsb_step 40 2003-10-16 17:17 dhsb_step 7441 2003-10-16 17:18 dhsb_step 6029 2003-10-16 17:18 dhsb_step 4917 2003-10-16 17:18 dhsb_step 7120 2003-10-17 8:36 dhsb_step 842 2003-10-17 8:36 dhsb_step 1071 2003-10-17 8:43 dhsb_step 34589 2003-10-17 8:43 dhsb_step 10445 2003-10-17 8:44 dhsb_step 11747 2003-10-17 8:44 dhsb_step 13780 2003-10-17 8:45 dhsb_step 21952 2003-10-17 8:46 dhsb_step 190 2003-10-17 8:46 dhsb_step 1382 2003-10-17 8:46 dhsb_step 40 2003-10-17 8:46 dhsb_step 631 2003-10-17 8:55 dhsb_step 90 2003-10-17 8:55 dhsb_step 591 2003-10-17 8:56 dhsb_step 40 2003-10-17 8:56 dhsb_step 230 2003-10-17 8:56 dhsb_step 891 |
|
|
|
|
|
数据情况是否不同？
|
|
|
|
调用参数略有不同,但是各数据处理流程不会有太大区别,
后来经过试验,调用耗时特别长的数据并无特殊,在测试时调用耗时正常! |
|
|
|
顶一顶
|
|
|
|
顶一顶
|
|
|
|
是不是并发处理锁住了记录？
|
|
|
|
不同时间段，访问进程数是否相同
|
|
|
|
进程数应该变化不大,我们系统只采用固定的2个连接,其他系统没有频繁的访问数据库操作
|
|
|
|
好好檢察一下當執行得很慢的時候有什麼別的操作造成資源的等待。
|
|
|
|
运行一下$oracle_home\rdbms\admin\utlbstat.sql 及 utlestat.sql 可以查看report.txt检查一下这两个时间段的统计信息
|
|
|
关闭