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.