More fun with Oracle Management Pack licensing

From: Allen, Brandon <>
Date: Mon, 13 Oct 2008 17:07:57 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450DAD31E5@NT15.oneneck.corp>

In another example of just how annoying Oracle's Management Pack licensing can be, I'm currently working on an SR where my support rep instructed me to run SQLTXPLAIN. I told him I was concerned that we may not be able to legally run sqltxplain since this is a standard edition database, which means we can't license the management packs even if we wanted to and there was some mention of the SQL Tuning Advisor (which requires a Tuning Pack license) in the sqltxplain docs.

He quickly assured me that sqltxplain does not require a license. I read through the documentation for sqltxplain on my own and found that, sure enough, it does indeed call dbms_sqltune by default, and therefore it clearly requires a Tuning Pack license for a default execution. It even states this explicitly in section 4.2 of the included instructions.txt file. Luckily, they were kind enough to build in a skip_tuning_advisor parameter that enables you to disable the call to dbms_sqltune so you can run sqltxplain and still remain in compliance with your license agreement.


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
Received on Mon Oct 13 2008 - 19:07:57 CDT

Original text of this message