- 论坛徽章:
- 0
|
本帖最后由 lottery009 于 2010-1-25 16:52 编辑
solaris 8 + oracle 8.17
做数据仓库用,每天都有入库操作,即把文本文件通过sqlloader把数据load到仓库中,但是从上个星期起,load的速度特慢,大概查了下,应该是IO的问题,不懂调整,请各位大虾帮忙
bash-2.03$ cat /etc/release
Solaris 8 2/04 s28s_hw4wos_05a SPARC
Copyright 2004 Sun Microsystems, Inc. All Rights Reserved.
Assembled 08 January 2004
bash-2.03$ uname -a
SunOS hn-dwsvr 5.8 Generic_117350-43 sun4u sparc SUNW,Sun-Fire-V440
#top
load averages: 1.72, 2.39, 2.14; up 807+03:47:39 16:32:09
172 processes: 169 sleeping, 1 zombie, 1 stopped, 1 on cpu
CPU states: 44.8% idle, 8.1% user, 2.0% kernel, 45.1% iowait, 0.0% swap
Memory: 16G phys mem, 7694M free mem, 31G swap, 31G free swap |
|