sqlldr 异常慢

显示全部楼层 · 2007-5-20 04:01:01

oracle 8.17 + solaris 8
每天都有入库操作，今天的入库特别慢
SQL> select event, sid, p1, p2 p3 from v$session_wait where event not like '%message%' order by p3 desc;
EVENT
SID P1 P3
------------------------------ ---------- ---------- ----------
db file sequential read
19 121133596
direct path write
283011071938
direct path write
253011036585
db file scattered read
41 12 592057
buffer busy waits
49 12 164064
db file sequential read
37 12 164064
pmon timer
1300
0
smon timer
5300
0
db file parallel write
2204
0
9 rows selected.

千问 · 2007-5-20 04:01:01

就这个看不出来具体问题？当时系统负载情况？

千问 · 2007-5-20 04:01:01

没什么负载和平时一样

千问 · 2007-5-20 04:01:01

抓个那个时间段的快照跑个sp报告贴出来瞅瞅