| 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. |
| utlxmv.sql |
Creates the MV_CAPABILITIES_TABLE for DBMS_MVIEW.EXPLAIN_MVIEW |
| 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 |
