创建表空间oracle10g,Oracle10g创建表空间慢问题

系统环境 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

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

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

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

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

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===============