Slow table space creation in Oracle 10 GB

System Environment

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, associatiction = 4
L1 Data: size = 16 KB, associativity = 4
L2 Instruction: size = 1024 KB, associatiction = 8
L2 Data: size = 256 KB, associativity = 8
L3 uniied: size = 9216 KB, associatiied = 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:

Database System: Oracle 10g r2

During installation, 80% of the system memory is allocated to the oracle database (about 10 Gb)

Problem:

Create a tablespace in the/data Directory
1G takes more than 2 minutes
2G takes more than 5 minutes

Create a tablespace in the/oradata directory
1G takes more than 5 minutes
2G takes more than 10 minutes

Install oracle 11g in the Windows System of the local machine,

1 GB is about 15 to 20 seconds, and 2 GB is about 30 to 40 seconds.

Why is it so slow to create a tablespace on hp-ux?

The simple table process on hp-ux is as follows:

$ Vi create_tablespace.sh
& Quot; create_tablespace.sh & quot; 10 lines, 395 characters
#! /Bin/sh
Echo "============ start date: 'date' ================"
Sqlplus/as sysdba <EOF
Create tablespace test1 datafile '/data/test1.dbf' size 1024 M;
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,200 5, Oracle. All rights reserved.

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

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
& Quot; create_tablespace.sh & quot; 10 lines, 394 characters
#! /Bin/sh
Echo "============ start date: 'date' ================"
Sqlplus/as sysdba <EOF
Create tablespace test2 datafile '/oradata/test2.dbf' size 1024 M;
Quit;
EOF
Echo "============ end date: 'date' ======================"

& Quot; create_tablespace.sh & quot; 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,200 5, Oracle. All rights reserved.

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

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
& Quot; create_tablespace.sh & quot; 10 lines, 397 characters
#! /Bin/sh
Echo "============ start date: 'date' ================"
Sqlplus/as sysdba <EOF
Create tablespace test4 datafile '/oradata/test4.dbf' size 2048 M;
Quit;
EOF
Echo "============ end date: 'date' ======================"

& Quot; create_tablespace.sh & quot; 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,200 5, Oracle. All rights reserved.

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

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
& Quot; create_tablespace.sh & quot; 10 lines, 397 characters
#! /Bin/sh
Echo "============ start date: 'date' ================"
Sqlplus/as sysdba <EOF
Create tablespace test3 datafile '/data/test3.dbf' size 2048 M;
Quit;
EOF
Echo "============ end date: 'date' ======================"

$ Vi create_tablespace.sh
& Quot; create_tablespace.sh & quot; 10 lines, 397 characters
#! /Bin/sh
Echo "============ start date: 'date' ================"
Sqlplus/as sysdba <EOF
Create tablespace test3 datafile '/data/test3.dbf' size 2048 M;
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,200 5, Oracle. All rights reserved.

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

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