Notes by Edward Stoever
Oracle Database Administrator and Application Developer
May 30, 2004

A list of UTL scirpts provided by Oracle
found in the RDBMS/ADMIN directory:

Script name     | Purpose
----------------|----------------------------------------------------------------
utlbstat.sql    | A pre-cursor to the modern statspack
                |
utlchain.sql    | Creates the default table for storing the output of the
                | analyze list chained rows command
                |
utlchn1.sql     | same as utlchain.sql
                |
utlconst.sql    | constraint check utility 
                | Script to check for valid date constraints. 
                |
utlcxml.sql     | PL/SQL wrapper over COREs C-based XML/XSL processor
                | This is the package header for the PL/SQL interface to CORE's C-based
                | XML Parser and XSL Processor. It currently does not provide an
                | interface to CORE's C-based DOM, SAX and Namespace APIs.
                |
utldst.sql      | Downgrade System Types compatibility
                | Run this script in order to downgrade the image format of the
                | system types from 8.1 compatibility to 8.0 compatibility.
                |
deptree.sql     | Show objects recursively dependent on given object
                | This procedure, view and temp table will allow you to see all
                | objects that are (recursively) dependent on the given object.
                | Note: you will only see objects for which you have permission.
                | 
utlenc.sql      | PL/SQL Package for ENCODE (UTL_ENCODE)
                | PL/SQL package to encode RAW data strings
                |
utlestat.sql    | This script will generate a report (in "report.txt") which will contain
                | usefull information for performance monitoring.  In particular
                | information from v$sysstat, v$latch, and v$rollstat.
                |
except.sql      | Creates table "exceptions"
                |
utlfile.sql     | Creates the package UTL_FILE. Do not run unless 
                | UTL_FILE does not exist on the database.
                |
utlhttp.sql     | HTTP requests from stored programs
                | The UTL_HTTP package makes Hypertext Transfer Protocol (HTTP) callouts
                | from SQL and PL/SQL.  It can be used to access data on the Internet over
                | the HTTP protocol.
                |
utlinad.sql     | PL/SQL Package for Internet address
                | This package allows a PL/SQL program to retrieve host name and
                | IP address information of local or remote host.
                |
utlincmp.sql    | UTiLity script to check for INCoMPatible 
                | objects in the database before a downgrade
                |
utlip.sql       | UTiLity script to Invalidate & Recompile Pl/sql modules
                | This script can be used to invalidate all existing PL/SQL modules
                | (procedures, functions, packages, types, triggers, views) in a
                | database so that they will be forced to be recompiled later on
                | either automatically or deliberately.
                |
utljavarm.sql   | Remove all java objects
                | This removes all the java objects from the data dictionary.
                |
UTLLOCKT.SQL    | Print out the lock wait-for graph in tree structured fashion.
                | This is useful for diagnosing systems that are hung on locks.
                |
utlnchar.sql    | The migration script for NCHAR data from 8i to 9i
   
                |
utlopslt.sql    | Utility to dump lock tree in OPS
                | Print out the lock wait-for graph in a tree structured fashion.
                | This script  prints  the  instance and OS PIDs (as instance-OS PID string in
                | the first column of the output) in the system that are waiting for global
                | locks,  and the locks that they  are waiting for.
                |
utlpg.sql       | PL/SQL Package of utility routines for Procedural Gateway. 
                | Creates Package UTL_PG.
                | Procedural Gateway specific routines to manipulate raws.
                |
utlpitl.sql     | UTiLity to reset Pdml ITL

                | This script needs to be executed to remove PDML ITL
                |
utlpwdmg.sql    | script for Default Password Resource Limits
                | This is a script for enabling the password management features
                | by setting the default password resource limits (ie complexity & expiration).
                |
utlraw.sql      | PL/SQL Package of utility routines for raw datatypes
                | Package spec of UTL_RAW (check if UTL_RAW is already there before running!)
                |
utlrefld.sql    | Load UTL_REF package on the server
                | Installs the utl_ref package on the rdbms.
                |
utlrp.sql       | UTiLity script Recompile invalid Pl/sql modules
                | This is a fairly general script that can be used at any time to
                | recompile all existing invalid PL/SQL modules in a database.
                |
utlsampl.sql    | Creates the famous SCOTT/TIGER schema
                |
utlscln.sql     | UTILITY SNAPshot clone
                | This file is an example of a procedure that clones a snapshot repschema.
                | This is an example.  It will not work for all snapshot repschemas
                | under all circumstances.
                |
utlsmtp.sql     | Creates the PL/SQL Package for Simple Mail Transfer Protocol (SMTP)
                | communication (Package Specification of UTL_SMTP)
                |
utlstddw.sql    | iMPORTANT -- THIS MUST BE RUN WHEN DOWNGRADING TO A PRE-8.1.6 
                | DATABASE AND BEFORE OPENING THE PRE-8.1.6 DATABASE
                |
utltcp.sql      | Creates the UTL_TCP package
                | This package provides TCP/IP client-side access functionality in PL/SQL.
                |
utltkprf.sql    | Grant public access to all views used by TKPROF with verbose=y option.
                | This file must be run while logged-in as SYS.
                | Catalog.sql must have been run before this file is run.
                |
utlurl.sql      | PL/SQL Package for URL (UTL_URL)
                | PL/SQL package to escape/unescape URLs.
                |
utlvalid.sql    | Creates the default table for storing the output of the
                | analyze validate command on a partitioned table.
                |
utlxmv.sql      | The utility script creates the MV_CAPABILITIES_TABLE that is
                | used by the DBMS_MVIEW.EXPLAIN_MVIEW() API.
                |
utlxplan.sql    | Creates the table that is used by the EXPLAIN PLAN
                | statement.  The explain statement requires the presence of this 
                | table in order to store the descriptions of the row sources.
                |
utlxplp.sql     | Script utility to display the explain plan of the last explain plan
                | command. Display also Parallel Query information.
                |
utlxpls.sql     | Script utility to display the explain plan of the last explain plan
                | command. Do not display information related to Parallel Query
                |
utlxrw.sql      | Outputs of the EXPLAIN_REWRITE goes into the table created
                | by utlxrw.sql (called REWRITE_TABLE). So utlxrw must be
                | invoked before any EXPLAIN_REWRITE tests.