Oracle Files of Interest
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to Request a Workshop for your organization today.
Purpose The purpose of this page in the Library is to capture information about text files located under $ORACLE_HOME that warrant specific attention to expose their value to the community.
File Name Description
addmrpt.sql Automatic Database Diagnostic Monitor (ADDM) report
addmrpti.sql Automatic Database Diagnostic Monitor (ADDM) report
addmtmig.sql Post upgrade script to load new ADDM task metadata tables for task migration
ashrpt.sql Active Session History (ASH) report
ashrpti.sql Active Session History (ASH) report with RAC and Standby Database support
ashrptistd.sql Active Session History (ASH) report helper script for obtaining user input when run on a Standby
awrblmig.sql AWR Baseline Migration
awrddinp.sql Retrieves dbid,eid,filename for SWRF and ADDM Reports
awrddrpi.sql Workload Repository Compare Periods Report
awrddrpt.sql Produces Workload Repository Compare Periods Report
awrextr.sql Helps users extract data from the AWR
awrgdinp.sql AWR global compare periods report input variables
awrgdrpi.sql Workload repository global compare periods report
awrgdrpt.sql AWR global differences report
awrginp.sql AWR global input
awrgrpt Script defaults the dbid to that of the current instance connected-to, then calls awrgrpti.sql to produce the Workload Repository RAC report
awrgrpti Report on RAC-wide differences between values recorded in two snapshots
awrinfo.sql Outputs general Automatic Workload Repository (AWR) information such as the size and data distribution
awrinpnm.sql Query the user for the name of the report file to be generated. The script generates a default name based on the instance number, begin snap id, end snap id and the type of report to be generated (text or html). This code is used for the SWRF reports, SQL Reports and ADDM reports.
awrinput.sql Common code used for SWRF reports and ADDM
awrload.sql Uses DataPump to load information from dump files into the AWR
awrrpt.sql Automated Workload Repository (AWR) report
awrrpti.sql Automated Workload Repository (AWR) report
awrsqrpi.sql Reports on differences in values recorded in two different snapshots
awrsqrpt.sql Produces a workload report on a specific SQL statement
awrupd12.sql Updates AWR data to version 12c. It only modifies AWR data that has been imported using awrload.sql, or data from before changing the database DBID
catalog.sql Builds the data dictionary views
catawrtb.sql Builds the AWR tables
catblock.sql Creates views that dynamically display lock dependency graphs
catclust.sql Builds DBMS_CLUSTDB built-in package
caths.sql Installs packages for administering heterogeneous services
catio.sql Allows I/O to be traced on a table-by-table basis
catnoawr.sql Script to uninstall AWR features
catplan.sql Builds PLAN_TABLE$: A public global temporary table version of PLAN_TABLE
dbfs_create_filesystem.sql DBFS create file system script
dbfs_create_filesystem_advanced.sql DBFS create file system script
dbfs_drop_filesystem.sql DBFS drop file system
dbmsiotc.sql Analyzes chained rows in index-organized tables
dbmspool.sql Enables DBA to lock PL/SQL packages, SQL statements, and triggers into the shared pool
dbmsupgnv.sql Recompiles PL/SQL objects for Native Compilation
dumpdian.sql Dumps Diana out of a database in a human-readable format (exec dumpdiana.dump('DMMOD_LIB')
epgstat.sql Shows various status of the embedded PL/SQL gateway and the XDB HTTP listener. It should be run by a user with XDBADMIN and DBA roles
hangdiag.sql Hang analysis/diagnosis script
noncdb_to_pdb.sql Given a DB with proper obj$ common bits set, converts it to a proper PDB by deleting unnecessary metadata
prgrmanc.sql Purges from RMAN Recovery Catalog the records marked as deleted by the user
recover.bsq Creates recovery manager tables and views ... read the header very carefully if considering performing an edit
sbdrop.sql SQL*PLUS command file drop user and tables for readable standby
sbdusr.sql SQL*Plus command file to DROP user which contains the standby statspack database objects
sbreport.sql This script calls sbrepins.sql to produce standby statspack report. It must run as the standby statspack owner, stdbyperf
scott.sql Creates the SCOTT schema objects and loads the data
secconf.sql Secure configuration script: Laughable but better than the default
spauto.sql SQL*PLUS command file to automate the collection of STATPACK statistics
spawrrac.sql Generates a global AWR report to report performance statistics on all nodes of a cluster
spcreate.sql Creates the STATSPACK user, table, and package
sppurge.sql Purges a range of STATSPACK data
sprepcon.sql STATSPACK report configuration
sprepsql.sql Defaults the dbid and instance number to the current instance connected-to, then calls sprsqins.sql to produce the standard Statspack SQL report
sprsqins.sql STATSPACK report
sql.bsq Drives the creation of the Oracle catalog and data dictionary objects
tracetab.bsq Creates tracing table for the DBMS_TRACE built-in package
userlock.sql Routines that allow the user to request, convert and release locks
utlchain.sql Creates the default table for storing the output of the analyze list chained rows command
utlchn1.sql Creates the default table for storing the output of the analyze list chained rows command
utlconst.sql Constraint check utility to check for valid date constraints
utldim.sql Build the Exception table for DBMS_DIMENSION.VALIDATE_DIMENSION
utldtchk.sql This utility script verifies that a valid database object has correct dependency$ timestamps for all its parent objects. Violation of this invariant can show up as one of the following:
  • Invalid dependency references [DEP/INV] in library cache dumps
  •  ORA-06508: PL/SQL: could not find program unit being called
  • PLS-00907: cannot load library unit %s (referenced by %s)
  • ORA-00600[ kksfbc-reparse-infinite-loop]
utldtree.sql Shows objects recursively dependent on given object
utledtol.sql Creates the outline table OL$, OL$HINTS, and OL$NODES in a user schema for working with stored outlines
utlexcpt.sql Builds the Exception table for constraint violations
utlexpt1.sql Creates the default table (EXCEPTIONS) for storing exceptions from enabling constraints. Can handle both physical and logical rowids.
utlip.sql 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 either automatically or deliberately.
utllockt.sql Prints the sessions in the system that are waiting for locks, and the locks they are waiting for
utlpwdmg.sql Creates the default Profile password VERIFY_FUNCTION
utlrdt.sql Recompiles all DDL triggers in UPGRADE mode at the end of one of three operations:
  • DB upgrade
  • utlirp to invalidate and recompile all PL/SQL
  • dbmsupgnv/dbmsupgin to convert PL/SQL to native/interpreted
utlrp.sql Recompiles all invalid objects in the database.
utlsxszd.sql Calculates the required size for the SYSAUX tablespace
utltkprf.sql Grants public access to all views used by TKPROF with verbose=y option
utlusts.sql Utility Upgrade Status: Presents Post-upgrade Status in either TEXT or XML
utlu122s.sql This script provides information about databases that have been upgraded to 12.2
utlvalid.sql Creates the default table for storing the output of the analyze validate command on a partitioned table
utlxaa.sql Defines a user-defined workload table for SQL Access Advisor. The table is used as workload source for SQL Access Advisor where a
user can insert SQL statements and then specify the table as a workload source.
utlxplan.sql Plan table creation script
utlxplp.sql Displays Explain Plan from PLAN_TABLE using DBMS_XPLAN built-in. Includes parallel run information
utlxpls.sql Displays Explain Plan from PLAN_TABLE using DBMS_XPLAN built-in. Does not include parallel query information.
utlxrw.sql Builds the REWRITE_TABLE for EXPLAIN_REWRITE tests
File Name Description
glogin.sql SQL*Plus global login "site profile" file. Add SQL*Plus commands here to executed them when en a user starts SQL*Plus and/or connects
plustrce.sql Creates the PLUSTRACE role required to use AUTOTRACE

Related Topics
BSQ Files
Morgan's Library
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved