首页 > Linux操作系统 > Linux操作系统 > Options for Reducing E-Business Suite Database Sizes

Options for Reducing E-Business Suite Database Sizes

原创 Linux操作系统 作者:chen_7733 时间:2009-02-16 15:31:27 0 删除 编辑

Options for Reducing E-Business Suite Database Sizes


  我还没有遇到一个会变小的数据库.像我们的腰围和美国的国债,所有的数据库的大小都注定要增加.对于E-Business Suite也不例外:当我们的生产力和业务增长时,你的应用数据库也如此.

Growth Control Methods

  • Archiving and purging
  • Database compression

Data Management Methods

A new Oracle whitepaper discussing these topics is now available:

This whitepaper discusses how these approaches can be used either individually or together to meet your requirements.  Some examples scenarios:

  • Adopt a 100% pure archive and purge strategy where any important data is initially archived and then finally purged when it is no longer needed. The archived tables could be placed in a read-only schema and the datafiles could be resized to reduce their physical space. In addition, database compression feature could be used in conjunction with or as an alternative to resizing the datafiles.
  • Customers could adopt a combination of an archive/purge and ILM strategy, where inactive data is put onto cheaper storage, then after a period of time, this data is archived and eventually purged. Alternatively, customers could choose not to use ILM but instead use database partitioning.
  • Customers could fully implement ILM and. and place less frequently accessed data, that would ordinarily be archived and purged, onto cheaper and less expensive storage devices.
  • Customers could use a 3rd Party archiving product with Oracle’s ILM product.

Although there's a lot of conceptual and strategically-oriented material in this whitepaper, it also has concrete and practical information about:

  • The E-Business Suite Purge Portal
  • Archiving and purging programs and affected tables for the following products:
    • Oracle General Ledger (GL)
    • Oracle Payables/Oracle Purchasing (AP/PO)
    • Oracle Receivables (AR)
    • Oracle Cash Management (CE)
    • Oracle Fixed Assets (FA)
    • Oracle Cost Management (CST)
    • Order Management (ONT)
    • Oracle Application Object Library (FND) and Workflow (WF)
  • How to use the Oracle ILM Assistant with an E-Business Suite environment
    • Defining data classes
    • Creating storage tiers for data classes
    • Creating data migration policies
    • Defining and enforcing compliance policies
  • Considerations when creating an information lifecycle management framework for Apps data

Related Articles

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量