昨天装了一个测试库,比较大,dmp文件有30G,重新建了个表空间和用户,导到一半的时候因为下班了,所以就把它断了,关机,回家之后打开本本,重新删了表空间和用户,再重新建了个表空间和用户,再导,大概一晚上导完了,然后就发现硬盘一直在读写,重启机器之后还是这样。
网上找了个方法,但是看不懂,哪位高手帮我看看怎么回事
select * from v$session_wait;
1 15 91 null event 1413697536 54435000 1 00000001 0 00 1 0 WAITED KNOWN TIME
2 1 154 pmon timer duration 300 0000012C 0 00 0 00 0 1 WAITING
3 2 239 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING
4 3 617 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 1 WAITING
5 6 5 rdbms ipc message timeout 180000 0002BF20 0 00 0 00 0 346 WAITING
6 7 96 rdbms ipc message timeout 500 000001F4 0 00 0 00 0 0 WAITING
7 4 318 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 1 WAITING
8 13 335 db file sequential read file# 1 00000001 block# 24972 0000618C blocks 1 00000001 0 0 WAITING
9 9 4822 db file scattered read file# 13 0000000D block# 1228521 0012BEE9 blocks 16 00000010 0 0 WAITING
10 5 184 smon timer sleep time 300 0000012C failed 0 00 0 00 0 44 WAITING
11 12 179 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 0 WAITING
12 8 137 wakeup time manager 0 00 0 00 0 00 0 29 WAITING
SELECT s.file#||'D' "FILE#+TYPE",d.name "DATAFILE",
                           s.phyrds,s.phywrts,
                           s.avgiotim,s.miniotim,
                           s.maxiowtm,s.maxiortm
          FROM v$filestat s,v$datafile d
          WHERE s.file#=d.file#
          UNION 
          SELECT s.file#||'T',t.name "DATAFILE",
                           s.phyrds,s.phywrts,
                           s.avgiotim,s.miniotim,
                           s.maxiowtm,s.maxiortm
          FROM v$filestat s,v$tempfile t
          WHERE s.file#=t.file#
          ORDER BY 1;1 10D C:\ORACLE\ORADATA\ORCL\XDB01.DBF 8 2 406329022 1 18 18
2 11D D:\ORACLEFILE\CONSUMER.DBF 4 2 -1224476879 2 13 15
3 12D D:\ORACLEFILE\CNMS.DBF 4 2 -1224476879 2 13 15
4 13D E:\ORACLEFILE\ZJUNICOM.DBF 142563 2 899297645 0 13 128
5 1D C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 1616 91 1976376298 0 53 172
6 1T C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 1616 91 1976376298 0 53 172
7 2D C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF 82 66 980958136 0 48 89
8 3D C:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF 4 2 -2012968904 2 8 15
9 4D C:\ORACLE\ORADATA\ORCL\DRSYS01.DBF 4 2 -435984854 2 6 15
10 5D C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF 44 2 -1089891926 0 6 15
11 6D C:\ORACLE\ORADATA\ORCL\INDX01.DBF 4 2 -435984854 2 6 16
12 7D C:\ORACLE\ORADATA\ORCL\ODM01.DBF 6 2 1737949811 2 5 15
13 8D C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 4 2 352507171 2 5 19
14 9D C:\ORACLE\ORADATA\ORCL\USERS01.DBF 4 2 -1307954562 2 18 18