Oracle 10g 建立資料表空間慢問題

系統內容

CPU info:
   Number of CPUs = 4
   Clock speed = 1595 MHz
   Bus speed   = 532 MT/s
   CPUID registers
      vendor information =       "GenuineIntel"
      processor serial number =  0x0000000000000000
      processor version info =   0x0000000020000704
         architecture revision:       0
         processor family:           32   Intel(R) Itanium 2 9000 series
         processor model:             0   Intel(R) Itanium 2 9000 series
         processor revision:          7   Stepping C2
         largest CPUID reg:           4
      processor capabilities =   0x0000000000000005
                      implements long branch:  1
        implements 16-byte atomic operations:  1
   Bus features
      implemented =  0xbdf0000020000000
      selected    =  0x0000000000000000

Cache info (per core):
   L1 Instruction: size =   16 KB, associativity = 4
   L1 Data:        size =   16 KB, associativity = 4
   L2 Instruction: size = 1024 KB, associativity = 8
   L2 Data:        size =  256 KB, associativity = 8
   L3 Unified:     size = 9216 KB, associativity = 9

Memory = 16364 MB (15.980469 GB)

Platform info:
   model string =          "ia64 hp server rx2660"
   machine id number =     d3a7307e-6c0c-11dc-9a43-073f36ab3df2
   machine serial number = SGH4735167

OS info:
   sysname  = HP-UX
   nodename = xxx
   release  = B.11.23
   version  = U (unlimited-user license)
   machine  = ia64
   idnumber = 3550949502
   vmunix _release_version:              

資料庫系統：Oracle 10g r2

安裝的時候把系統80%的記憶體都分配給oracle資料庫（大概是10G左右）

問題：

在/data目錄建資料表空間
1G需要時間為2分多鐘
2G需要時間為5分多鐘

在/oradata目錄建資料表空間
1G需要時間為5分多鐘
2G需要時間為10分多鐘

在原生window系統下安裝oracle 11g，

建立資料表空間1G大概15到20秒，2G大概30到40秒左右。

為什麼在hp-ux上建立資料表空間會那麼慢呢？

具體在hp-ux上簡表過程如下：

$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 395 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <<EOF
create tablespace test1 datafile '/data/test1.dbf' size 1024M;
quit;
EOF
echo "===========end date:`date`==============="
$ ./create_tablespace.sh
===========start date:Mon Dec  5 10:55:48 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 10:55:48 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
===========end date:Mon Dec  5 10:57:53 EAT 2011===============
$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 394 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <<EOF
create tablespace test2 datafile '/oradata/test2.dbf' size 1024M;
quit;
EOF
echo "===========end date:`date`==============="

"create_tablespace.sh" 10 lines, 397 characters
$ ./create_tablespace.sh
===========start date:Mon Dec  5 10:59:13 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 10:59:13 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
===========end date:Mon Dec  5 11:04:01 EAT 2011===============
$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <<EOF
create tablespace test4 datafile '/oradata/test4.dbf' size 2048M;
quit;
EOF
echo "===========end date:`date`==============="

"create_tablespace.sh" 10 lines, 397 characters
$ ./create_tablespace.sh
===========start date:Mon Dec  5 11:05:32 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 11:05:32 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
===========end date:Mon Dec  5 11:16:03 EAT 2011===============
$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <<EOF
create tablespace test3 datafile '/data/test3.dbf' size 2048M;  
quit;
EOF
echo "===========end date:`date`==============="

$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <<EOF
create tablespace test3 datafile '/data/test3.dbf' size 2048M;  
quit;
EOF
echo "===========end date:`date`==============="

$ ./create_tablespace.sh
===========start date:Mon Dec  5 12:43:34 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 12:43:34 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
===========end date:Mon Dec  5 12:47:39 EAT 2011===============