Local/Dictionary Managed DB info

原创 2004年07月13日 12:19:00
Local/Dictionary Managed DB info

前段时间,我遇到了一个问题百思不得其解,问了许多人也不得其门而入。一个偶然的机会,在电话上面与一个软件厂商的DBA谈起,他也遇到过同样的问题,并做了分析。我无法肯定他的分析是正确的,但是贴出来给大家参考。

这次贴出的是问题,及对方的分析:里面涉及一些厂商软件的名字,请大家忽略。

问题:

Paul/ Vince/ Brendan,
What is the difference between a database that was initially configured as a data dictionary table space vs.... local database, we are seeing installation errors when attempting to install to a 'data dictionary's table space. It was my understanding in the differences was performance not structure.
The ISSUE we are seeing as as follows:

The database was initially configured as a data dictionary tablespace with 100MB of space available. The initialization of the database during the installation of the base integration server failed by running out of space when trying to create the extent of table 75. The database administrator checked the database after the failure and determined that the database had been filled up to 99MB and the attempt to create the next table after reaching the 99MB point is what caused the failure.

The database administrator then increased the size of the tablespace to 300MB and the db_setup.sh script was executed manually with the NOPROMPT parameter on the command line. The initialization of the database failed again. This time the database filled to 299MB before failing on the creation of an extent for a table.

The database administrator then changed the table space from a data dictionary tablespace to a local tablespace with 300MB of space available. The db_setup.sh was executed manually again with the NOPROMPT parameter on the command line. This time the database was successfully initialized.
According to the database administrator , the only difference between the two type of table spaces is in performance not structure?
The database flavor in use is ORACLE. The database does not reside on a different host system from the one that Sterling Integrator was installed upon. In the installation guide for Sterling Integrator, there is no mention in the section on setting up an ORACLE database for Sterling Integrator on the type of tablespace that should be created. Is this something we should be concerned about for future installations of Sterling Integrator?

Is this something that has already been explored in regard to Sterling Integrator or is examination in the development lab needed to try to determine the cause of the issue?
Alison Drouillard
Sterling Integrator (ext.7868)
L:2 Technical Support Specialist

分析:

This questions has to do with how the oracle DB is set up to handle extent managment. I would suggest you refer them (and yourselves) to this article:
http://www.oracle.com/oramag/oracle...tml?o60o8i.html

It explains very well how extents work in oracle.

As for SI being created in a DB (that has been created as a data dictionary table space) what I can say is that, based on how our DBs and tablespaces here in house are configured, we have only used the 'Locally Managed' extent scheme. Currently there is a problem in creating a data dictionary table space if the Data Base 'System' tables are created as Local. Basically the whole DB must be created as a data dictionary style before you can create data dictionary tablespaces. I'm not sure about the converse, but based on Allisons' very detailed explanation I will assume that you CAN create locally managed tablespaces on a DB that was originally configured as a data dictionary style DB.

What I think may be happening with our db_setup.sh failing in the data dictionary creation probably pertains to the "Dictionary-Managed Tablespaces"
section of the above oracle article. They proabably have configured their extent sizes too small (in their data dictionary tablespace) and we cannot find a large enough contigus block of data to write data to. How large do we need to specify you ask? That I do not know. What I do know is that data dictionary tablespace configuration is an art and can be used to fine tune oracle DB's for a specific purpose. One of the main reasons for 8i to introduce locally managed extents is because of the complexity of dictionary extent configuration. Most DBA's love the locally managed scheme because it is easier to configure and it has been known to be fast. (oracle manages all data in the tablespace)

To conclude, unless we want to get into DB configs in documentation for the scenario of dictionary managed tables, we whould probably specify locally managed extent tablespaces to be used with SI.

Any input Vince/Wade?

Brendan

ORA-12913: Cannot create dictionary managed tablespace

Check this info from Oracle, ORA-12913: Cannot create dictionary managed tablespace Cause: An atte...
  • msdnchina
  • msdnchina
  • 2011年04月15日 09:44
  • 941

怎样连接SQL Server Local DB

一、什么是SQL Server Local DB Microsoft SQL Server 2014 ExpressLocalDB是面向程序开发人团的SQL Server Express的执行模式,...
  • cuckoojosh
  • cuckoojosh
  • 2015年11月13日 16:13
  • 2958

Locally vs. Dictionary Managed Tablespaces

导读:  Submitted by admin on Tue, 2003-07-01 12:31.RDBMS Server  When Oracle allocates space to a segm...
  • Xviewee
  • Xviewee
  • 2008年09月17日 22:38
  • 840

gdb之info/show命令

一、gdb命令 相对于常见和常用的backtrace,break,watch,step之类的指令来说,这两个都是相对比较小众的功能。只管来说,小众的功能就是使用的人比较少的功能,而使用的比较少的原因...
  • lenk2010
  • lenk2010
  • 2013年08月21日 14:23
  • 1979

The local variable XXXX is never read

   eclipse编译时出现警告提示:The local variable XXXX is never read,是什么原因呢?程序可正常运行!      这个选项是可以设置的:Window -->...
  • momohah2008
  • momohah2008
  • 2008年08月04日 19:59
  • 275

Reading from a Mailslot/Writing to a Mailslot

The process that creates a mailslot can read messages from it by using the mailslot handle in a call...
  • smwhotjay
  • smwhotjay
  • 2018年02月04日 09:31
  • 127

duplicate global variable looked up by string name

处理方法: 将常量变量的引号去掉: cudaMemcpyToSymbol("g_fCubeRange",     &_pMCGrid->m_fRange,         sizeof(float...
  • hongqiang200
  • hongqiang200
  • 2011年09月13日 14:29
  • 809

W3C Indexed Database API

html5中 3. Indexed Database API 3.1 Constructs 3.1.1 Database
  • cainiaokan
  • cainiaokan
  • 2014年06月08日 19:28
  • 1353

Flask-Migrate数据库迁移

在命令行中实现数据迁移, 工程放在F:/ERP1/server中 开始准备工作:使用命令安装Flask-Migrate包 pip install flask-migrate ...
  • qq_20711445
  • qq_20711445
  • 2016年06月29日 20:52
  • 275

tensorflow入门(一)

学习个人笔记
  • u010197508
  • u010197508
  • 2017年06月08日 03:12
  • 411
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Local/Dictionary Managed DB info
举报原因:
原因补充:

(最多只允许输入30个字)