oracle建表空间特别慢,ORACLE 10G ASM创建一个表空间非常慢问题.

SQL> select * from v$asm_disk;

GROUP_NUMBER DISK_NUMBER COMPOUND_INDEX INCARNATION MOUNT_STATUS

------------ ----------- -------------- ----------- ------------

1           0       16777216  1046308908 OPENED

1           1       16777217  1046308902 OPENED

1           2       16777218  1046308905 OPENED

1           3       16777219  1046308906 OPENED

1           4       16777220  1046308904 OPENED

1           5       16777221  1046308903 OPENED

1           6       16777222  1046308907 OPENED

1           7       16777223  1046308901 OPENED

8 rows selected

SQL> select * from v$asm_diskgroup;

GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB

------------ ------------------------------ ----------- ---------- -------------------- ----------- ------ ----------

1 ASM                                  512       4096              1048576 CONNECTED   NORMAL      81920

SQL> create tablespace test datafile '+ASM' size 4096M;

等待了很久都没有创建完,正式环境却很快.

SQL> select distinct sid from v$mystat;

SID

----------

137

SQL>

SQL> select sid,event From v$session_wait;

SID EVENT

---------- ----------------------------------------------------------------

129 SQL*Net message from client

134 Streams AQ: waiting for messages in the queue

137 SQL*Net message to client

143 Data file init write

144 Streams AQ: waiting for time management or cleanup tasks

146 jobq slave wait

150 Streams AQ: qmn coordinator idle wait

154 SQL*Net message from client

155 class slave wait

156 rdbms ipc message

157 ASM background timer

158 Streams AQ: qmn slave idle wait

160 rdbms ipc message

161 rdbms ipc message

162 rdbms ipc message

163 rdbms ipc message

164 smon timer

165 rdbms ipc message

166 rdbms ipc message

167 rdbms ipc message

SID EVENT

---------- ----------------------------------------------------------------

168 rdbms ipc message

169 rdbms ipc message

170 pmon timer

23 rows selected

SQL>

请问是啥原因呢?

aix 5.3+oracle 10.2.0.3