Oracle 10g 创建表空间慢问题

系统环境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    = 0x0000000000000000Cache 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 = 9Memory = 16364 MB （15.980469 GB）Platform info:
   model string =          "ia64 hp server rx2660"
   machine id number =     d3a7307e-6c0c-11dc-9a43-073f36ab3df2
   machine serial number = SGH4735167OS 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 2011Copyright （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 optionsSQL> 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 2011Copyright （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 optionsSQL> 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 2011Copyright （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 optionsSQL> 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 2011Copyright （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 optionsSQL> 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 进程查看v$sessionOracle 调度程序学习相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）

表情：姓名：匿名字数

<button class="layui-btn layui-bg-purple" id="dofav">收藏该网址</button>
        </div>
    </div>
</div>
<div class="copyright">
    <div id="footbar">
        版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a>
    </div>
</div>
<script> var _mtj = _mtj || [];
(function () {
    var mtj = document.createElement("script");
    mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(mtj, s);
})(); </script>
<script src="/static/lib/layui/layui.js"></script>
<script src="/static/lib/jquery/jquery.js"></script>
<script src="/static/lib/ajax.js"></script>
<script>
    layui.use(function () {
        var layer = layui.layer;
        var $ = layui.jquery;
        $("#dofav").click(function () {
            var artid = $(".article").attr("artid");
            var params={
                artid:artid,
                addtype:'escdns_article',
                t:Math.random()
            };
            if(artid>0){
                ajax.request({
                    method: "/index/article/addfavorite", type: "post", callback: function (res) {
                        layer.msg(res.msg);
                    }
                },params);
            }
        })
    })
</script>
</body>
</html>