在HP-UX系统上，使用Oracle 10g创建表空间时，相比于Windows环境，速度显著减慢。例如，在/data目录下创建1G表空间耗时2分钟多，2G则需5分钟多；而在/oradata目录下，相应时间分别为5分钟和10分钟。与之对比，Windows环境下Oracle 11g创建相同大小的表空间只需15到40秒。问题可能与系统配置、磁盘I/O性能、数据库参数设置等因素有关。
系统环境 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
最低0.47元/天 解锁文章
2120
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
