This discussion is archived
4 Replies Latest reply: Apr 17, 2012 5:27 AM by 931175 RSS

Change Management pack and Tuning Packs Usage

user13312943 Newbie
Currently Being Moderated
Hi,
I would like to know if my oracle databases are using change management pack or not.
From the link below, I see change management pack has several features.

http://docs.oracle.com/cd/B28359_01/license.111/b28287/options.htm#CIHBGJCC

If I use DBA_FEATURE_USAGE_STATISTICS, for example for partitioning, I can find the first usage date and if it currently used or not.
How can I get similar information for Change Management Pack and Tuning Packs?

Thank You
Sarayu
  • 1. Re: Change Management pack and Tuning Packs Usage
    KuljeetPalSingh Guru
    Currently Being Moderated
    To control Diagnostic Pack and Tuning Pack

    Beginning with Oracle Database 11g, the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter controls access to the Diagnostic Pack and Tuning Pack. You can set this parameter to one of the following values:

    DIAGNOSTIC+TUNING — Diagnostic Pack and Tuning Pack functionally is enabled in the database server.

    DIAGNOSTIC — Only Diagnostic Pack functionality is enabled in the server.

    NONE — Diagnostic Pack and Tuning Pack functionally is disabled in the database server.

    Thanks
    Kuljeet pal Singh
  • 2. Re: Change Management pack and Tuning Packs Usage
    KuljeetPalSingh Guru
    Currently Being Moderated
    Change Management Pack
    The Change Management Pack for Oracle Database enables administrators to evaluate, plan, and implement database schema changes to support new application requirements without error and data loss while minimizing downtime. Using the Change Management Pack, administrators can investigate and track complex changes, compare and synchronize objects and schemas, modify schema objects, evaluate the change impact, and if required, undo previous changes. The Change Management Pack makes change management simple and efficient, and minimizes chances for error, thereby reducing the opportunity for data loss and system down-time.


    In order to use the features of Change Management Pack , you must install the Java console version of Enterprise Manager, which you can find in the /companion directory of the installation medium. The use of this interface requires licensing of the Change Management Pack.

    Licensed Links
    The following licensed pages and links of this pack apply to change management for Oracle Databases.

    From the Grid Control Home page, select the Databases sub-tab. In the Related Links section, the following links and associated pages are licensed as part of the pack:

    Dictionary Baselines

    Dictionary Comparisons

    http://docs.oracle.com/cd/B19306_01/license.102/b40010/database_management.htm
  • 3. Re: Change Management pack and Tuning Packs Usage
    user13312943 Newbie
    Currently Being Moderated
    Thanks Kuljeet for your reply.
    We have some databases on 10G and some on 11G. Is there any way we can query a datadictionary view to find out if Change management Pack is ever used on Oracle 10g similar to how we can get other options like partitioning or RAC from DBA_FEATURE_USAGE_STATISTICS?

    Thanks
    Sarayu
  • 4. Re: Change Management pack and Tuning Packs Usage
    931175 Newbie
    Currently Being Moderated
    [http://www.dbmaestro.com]
    A great complement to your Oracle Database and a superior alternative to the change pack
    is the TeamWork change management solution.
    I suggest you check it out here http://www.dbmaestro.com


    In addition to all the benefits of the change management pack
    TeamWork offers a lot more and integrates as part of the development process.
    Some outstanding features offered by TeamWork:
    3 way analysis , check in/check out process for updates, change policy enforcement,
    Enables rollbacks of specific objects to specific points in time.

    Edited by: 928172 on 05:26 17/04/2012

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points