存储过程执行耗时波动请教!!急

TLFLY 2003-10-20 07:56:49
以下为程序运行过程中对同一存储过程调用耗时的记录,请问为何会出现如此大的波动情况?(从最小的40ms到最到的35000ms),存储过程主要执行插入操作
日期时间 存储过程 执行耗时(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
...全文
54 9 打赏 收藏 转发到动态 举报
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
TLFLY 2003-10-21
  • 打赏
  • 举报
回复
顶一顶
beckhambobo 2003-10-21
  • 打赏
  • 举报
回复
不同时间段,访问进程数是否相同
tw_cshn 2003-10-21
  • 打赏
  • 举报
回复
是不是并发处理锁住了记录?
TLFLY 2003-10-21
  • 打赏
  • 举报
回复
顶一顶
tsj68 2003-10-21
  • 打赏
  • 举报
回复
运行一下$oracle_home\rdbms\admin\utlbstat.sql 及 utlestat.sql 可以查看report.txt检查一下这两个时间段的统计信息
jiezhi 2003-10-21
  • 打赏
  • 举报
回复
好好檢察一下當執行得很慢的時候有什麼別的操作造成資源的等待。
TLFLY 2003-10-21
  • 打赏
  • 举报
回复
进程数应该变化不大,我们系统只采用固定的2个连接,其他系统没有频繁的访问数据库操作
TLFLY 2003-10-20
  • 打赏
  • 举报
回复
调用参数略有不同,但是各数据处理流程不会有太大区别,
后来经过试验,调用耗时特别长的数据并无特殊,在测试时调用耗时正常!
hdkkk 2003-10-20
  • 打赏
  • 举报
回复
数据情况是否不同?

17,078

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧