系统环境 cpu info: number of cpus = 4 clock speed = 1595 mhz bus speed = 532 mt/s cpuid registers vendor
系统环境
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 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 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 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 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 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===============