oracle 10g 创建表空间慢问题
来源:互联网 发布:淘宝客微信群机器人 编辑:程序博客网 时间:2024/06/05 18:07
系统环境
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===============
- oracle 10g 创建表空间慢问题
- ORACLE 10G创建表空间
- oracle 10G创建表空间
- oracle 10G表空间页面打开慢(非常慢)的解决方法
- ORACLE 10G创建表空间和创建用户
- Oracle 10G字段排序慢问题
- PLSQL Developer 给oracle 10g 创建表空间
- oracle 10g 创建和删出表空间,用户,表
- 利用PLSQL Developer 给oracle 10g 创建表空间
- 在oracle 10g中创建、删除表空间
- 利用PLSQL Developer 给oracle 10g 创建表空间
- Oracle 10g创建表空间的完整步骤详解
- Oracle 10g 创建表空间的完整步骤详解
- Oracle 10g表空间创建的完整步骤
- Oracle 10g创建表空间的完整步骤详解
- Oracle 10g创建表空间的完整步骤详解
- Oracle 10g创建表空间的完整步骤详解
- Oracle 10g创建表空间,用户,授权,导入导出
- 最常用的性能视图——总结(4)!
- 【转载】使用C#2.0进行文件压缩和解压
- Oracle安装以及测试Oracle数据库
- live555学习笔记-UsageEnvironment和TaskScheduler
- genSerial
- oracle 10g 创建表空间慢问题
- ServiceManager管理的服务——《android内核剖析》笔记
- renren api (4) 显示好友列表
- 2011.11-项目问题汇总
- getSubStr
- Windows下获取本机MAC地址的方法
- #pragma warning 启用和禁用warning
- 关于测试文档
- diff/patch 的使用