This article applies to DPA versions 9.0 and above and Ignite versions 6.5 and above.
UTL_CON is a package that DPA installs into the SYS schema in an Oracle database when it is registered. It is used for a varierty of things including DPA upgrades, getting live plans (the DPA monitoring user is not privileged), DPA version information, etc.
PROCEDURE EXPLAINPLAN - This procedure is used when a DPA GUI user requests a live explain plan from the SQL page. The DPA user is not privileged so it does not have permissions to see or read every table that a user would request a plan against. Thus, this procedure will run as the SYS user and get the plan for the SQL text passed in.
PROCEDURE GP - GP stands for Grant Permission and is used only during upgrades. An example of this requirement is if a new feature is added that needs access to a new table table. For example, when DPA/Ignite 8.0 came out, it included a live plan collection feature that retrieved data from V$SQL_PLAN. The previous version did not require that privilege, so during the upgrade this procedure is called to grant read access to this table.
PROCEDURE MPROC - Used to get hot block information. This procedure is deprecated because the feature is no longer present, but remains here for future use.
FUNCTION VERSION RETURNS NUMBER - Used for DPA to determine if an upgrade is required when the monitor is started.
Note: Each of the above procedures/functions requires a security key as one of the parameters which only the DPA software knows. No one else can utilize this package without that security key.
For various reasons, such as change control, security, etc, some companies want to remove this package. It can be dropped, but the features that would be missed or altered are as follows:
If these limitations are not an issue, the UTL_CON package can be dropped.