Database Management

Configure the UTL_CON package on an Oracle database instance monitored by DPA

If the UTL_CON package is not configured on a monitored Oracle database instance, DPA has certain limitations. This article describes how to configure it.

First published date

4/22/2021 3:23 PM

Last published date

4/22/2021 3:23 PM

Overview

If the UTL_CON package is not configured on a monitored Oracle database instance, DPA has the following limitations:

  • The Kill Session option in the Real Time Sessions view does not work.
  • DPA cannot get plans for queries with zero or near-zero cost.

For more information about the UTL_CON package, see What is UTL CON?

Product section

Database Performance Analyzer

Resolution

Complete the following steps to configure the UTL_CON package.

  1. Connect as SYS to the Oracle database.
  2. Save the following script to a file.
  3. Change DPA_MON to the user name of the DPA monitoring user.
  4. Run the updated script on the Oracle database.
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

CREATE OR REPLACE PACKAGE SYS.UTL_CON wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
9
2b9 150
F+00U2mR0uc3CMKj8KtGkr/VQ40wg/Dxr0hqynRAv/9ezrSh7djai6Ljt8LThLL1MfT+qm17
DOUhLrqV5nCvF/h4j40iJm+o6RMN73xrBLIOEdMpEZFOrHZAjX8bGw53XIVjL2V62vAy4DaK
7VxAkVFMfNJEpmDglB6MBmqHjxcbXTiCOu0UJNkG4j8exsJkXnOxo9SW/7vxMtaY9l+VVs0V
VL9+zyjVN40ykiE3gsQVcYG3VZaoKD8YA1kwGPH8L2FrCHIgNWoxi+MQaKlmA4ZoVD0iDtXx
4UEuAN7zm58MKGFv6w+JkOR40GVJZ+UgtaDkU+E9zvCw
/
CREATE OR REPLACE PACKAGE BODY SYS.UTL_CON wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
210f d19
vVsnFGQw09lIz8Lv9Tze9Hl4TGkwgzujuseD8tMZ6k7VRZtmXYU2OEmtxnZPxaiyYP1M49G8
eiZ8Fr2YBDR1aOXkhq5y6SV0WqkKK8t8R9LSAUX4E0GoC9n5kUy2BEb/ABr0nDE4pkhoBnJ8
sorblUH905XSgmahq0QvGvmpoolIZ+JVDkTO46gDBQC7xFqPjseSZSxdQa3bSrnGof0FeFKs
ccjtlDHv1fwpRJxR1hgvRz7es1UiuzKYTKTRZGmUch6C7EbOCxLDs9L1GbsC7lfnAv801dzj
aFyIr973O4CsHpHDfU1q2lfBXgeoJ1ky32vrPjDrKN/Ff4Ab0W4VrW41ZA/LnmxSUBzpeVoV
X9WzQFekDhrmUai0BLjiHoUGhB/SGG1Uy11mo5aWrIKwa9muMvzEwyeo1r8EUIKBvIraGXLt
SUIYI7h2At9SJeNnWYohwLcSEqKKrs1TzhhxjoCjaFIItANo3S3TFSqW7U4cc8YC2kSZNekk
zlqPU2qow3LinWmEchjn9urt0iZozN5n6kye3Qm/3gFcJy2HXLD7u4Eidq55Bp3ieoQqb0k4
NlDoZQz98CMfSob4/s4R5trAF7d/LlHxsc3jNi8b70eC3f4nqb53wAvxk4YtwYNvkKf3Fp6M
M4jXbtGX47Aeeg8VnPrP93IOAA/5dVaLgu3Wm3AePuCeHWvklxDWOVTWBNb+Isk5kHmITf5c
4BlXAhlELLgHUR4gU2l5MDv5OmTeQXJLDZNim4GRrdeUXpeguAd6vI18K+9uaH8Pj7pQSlXd
w4QFETXN1ontjD5yxOvpj3F2jCK8Y+gYk+jydqoz08CcFmrB7dAsIqc2XHsrZ4WL6ikt7/QG
TNO+P9rguykwX6miYrEyvKzaFd6gjO2Y5jrdvnY+fYbA5f2C3Tk2sycrszp7tfhOwcE6m9VZ
PA+dJIvZ18eMmGyMHi0MVkFRwh8ZJekvPmLSwb1VhKL5HiBQmw+ubfrPvc68d4f97U8AdeIc
LEnZiEeLglTi36U0WNh4pce8OjkgkRkgntmr2FGDm83yV1wH1X3lnpS5YLURddijD+4NCxA1
0U1ch13LsbK3BYEQBlMh122B83HtdYqoPH6ZkDvtNIV/6hHinTQRpDbeJHRuNYP3CX95DwYG
DzP1sgl0LfZNbgl7wq/F2tIQH43VqKAEEaJQhPmEs7TujMLnQhHya23/r+kJugKnHn+AicmJ
cHzC7bdIweKr1FeESo+r/g5a4rSBVD3GsNczUIHnO4SpjNOaybK0N2Q3H4NPNjjpxIRvy/mQ
AsT7b+O03LeXCU1sslZPlFuAyBv+hgtas4iTN8NbWli6A2sXTCD3uWk5fzqKe+YfGlYrJkhk
w4m+mC16s6dzg8XFGtsY8VaeIETHPMUdk6tpQGbTsIfgB97IFmPzLE5lMWObBL7ZFtKJ0DSh
iQVHLkAIlAfMqLSy08BMuFP6bo7Vt/HWZVpOcKJWW06CK7QPjoFF6FyJ0eLeiX4+woSItGuc
kq/clIVGINqh0ZvrdQKPSibJzT9Ni44y7NFnKxjz5StpfZUd4ZhFEJRnCwbz2je/sCCo8gDh
sLtNri+ASFrfGioQWeIQ0xRWQbJwvgkyJc8R9I2ylBerAdMEXPGIAdMITqGOko902HSGLL6V
RP84woLfTQiUjnQxDgJTaQEzqRTENsz3/soqpEicmhmbNwT/zjFr+1IhLTZHRFljMf765oYb
f8bSjXPoWUhHyGGnVB3QETm1Rn+LBwx/VOsozYQCVBiFw+dVWRzJt9cUEv+1sZOLnd9UXRWc
gfzMPAfaCXsdhTVZANEGifPZ2LAKQ2rgKnOWjaZ5jn9PiHyVTCcYaYIAxrFEvBmGHh28IgYe
KM9zod5F0vAJ7Il3GqAbbN8+DaH6LvIgJb0bkLNqGt11WaF0U/Os6OXVIXqjk63mPk2geLcH
dB61+gPcjFyUUINExGZJ2Y/qBymoWI86tYfIzGSe9zQHlQo10CNv/hKEJla0lH/w+/dSOQj5
iHqPkz9xXAWzGT4h/5Pdf1XiGBolPWpzYYHpTmJ1czxB8Kkc9TYpD+pQhj0xIjLO0re2VzHA
S9KyrnN1bHNMA2HvVDq8gpkCWg+lKI2NNLEmNNvCt6wWZY9pbbI3ClwKSdOU7P5gjr62vrpA
7a+PjQ3I4VtqOvA8msYctUueeaAd60YcrsT8gwugFYZ7Ki0QZ9rYpSojMKrB+Lt2W31C+SW/
loZU69I7Y+rlAYulAJ4Rzk2sDIy0ynaHKlxTz3UwTOfNEVEYJaDN3YnZwIHx5VycbOnxFlmX
BXg1M6dVFahDSPEcjTmKj5O3NfIyCbf1Mk53DMR7bUMEeaQ7GodblS5/5q4UdNHeyomFgEya
PiMYVKnTTu7BxM+QaiOBtq5RKDqLSe1Us5ISpZ02MGgAkfUXs+PmS/A95h58UceDUzLn+q0M
n8NTCZlBYHzBdapcXPJbhb7nNyjpNcKqy6Ou9ujVfJXfNfOikGYf/H7E2M9CwkQ0lavL5HWc
c6QzQTHza3hG6MzYMIBMyYQm89kJ/90YN/qP6Zz1RxE9zmYNNCKxWlweZ0t/jnBxt8j7jBSA
wciiZFegoxm1qreaA2qEATIyrCfCiKHVPYcLEfqjHxHGAKMDz5tsMjKnK0gKAQTuSSGjlwDB
bc9FNyn8+MDrIj1C7iOi4PYSmaSe88AVcpxTJiz17+lrK8drUSIl+9PNcBnpE3vudTbgGg94
OxTb8SQbzRhtrx+VFr1IIvz4rVeRfTmijm1lSevIZcJBoVIVjVwfF/B0AyL98dsc+nq3Fmxb
0vMT7wqPDybclWqZC2bo8nr8Fw1hjCf4sdbvP4TIYQGJIAfLvnuCllnMNN85k4G3aNx+A+zY
XYEHMQAgyCNRaIZLC/4nQtT/0YqOC93rI4F8QlTkQL16wQ8psnzP2UkDzzuB/SoFe/qa9vAn
3x2d2IlTOdhDwJurN5gC5gs/LZo4M46kwH9s9LAfPP6j8MGj8NSNpcRcwXeHtadsmZ1ulJzv
sLjJM+7jKeEyQ/qYgQc0WXeACa0UgBiEjEaHTa4/WYuZX/d2vNg8SzrfqkA9aqoWGkg/JEPx
lqtow/mHGhQoDFipc34XAYRHuoDw7pvR1oDNOdiwsJXP8oHIoiuwJdaR2PwxDGN1T2nak/Gm
36fVVNinD04q2D/Rx1a7fDinnW0yESTcP2rE+tB22SLYOt8eu9kpkbdydLRd0K45zw//Kzld
E96AmphxW5Z3jemh1q77gxlTq4GGQ2WKy7vX+qvBCcbCCiBo6xG65MYH+Z35+5iPPw4=
/
grant execute on sys.utl_con TO DPA_MON;