CATBLOCK.SQL |
Performance management |
SYS |
Creates views that can dynamically display lock dependency graphs |
CATEXP7.SQL |
Exporting data to Oracle7 |
SYS |
Creates the dictionary views needed for the Oracle7 Export utility to export data from Oracle8i in Oracle7 Export file format |
CATHS.SQL |
Heterogeneous Services |
SYS |
Installs packages for administering heterogeneous services |
CATIO.SQL |
Performance management |
SYS |
Allows I/O to be traced on a table-by-table basis |
CATOCTK.SQL |
Security |
SYS |
Creates the Oracle Cryptographic Toolkit package |
CATPARR.SQL |
Oracle Parallel Server |
SYS or SYSDBA |
Creates parallel server data dictionary views |
CATQUEUE.SQL |
Advanced Queuing |
|
Creates the dictionary objects required for Advanced Queuing. |
CATREP.SQL |
Advanced Replication |
SYS |
Runs all SQL scripts for enabling database replication |
CATRMAN.SQL |
Recovery Manager |
RMAN or any user with GRANT_RECOVERY_CATALOG_OWNER role |
Creates recovery manager tables and views (schema) to establish an external recovery catalog for the backup, restore, and recovery functionality provided by the Recovery Manager (RMAN) utility |
DBMSIOTC.SQL |
Storage management |
Any user |
Analyzes chained rows in index-organized tables |
DBMSOTRC.SQL |
Performance management |
SYS or SYSDBA |
Enables and disables generation of Oracle Trace output |
DBMSPOOL.SQL |
Performance management |
SYS or SYSDBA |
Enables DBA to lock PL/SQL packages, SQL statements, and triggers into the shared pool |
USERLOCK.SQL |
Concurrency control |
SYS or SYSDBA |
Provides a facility for user-named locks that can be used in a local or clustered environment to aid in sequencing application actions |
UTLBSTAT.SQL and UTLESTAT.SQL |
Performance monitoring |
SYS |
Respectively start and stop collecting performance tuning statistics |
UTLCHN1.SQL |
Storage management |
Any user |
For use with Oracle8i. Creates tables for storing the output of the ANALYZE command with the CHAINED ROWS option. Can handle both physical and logical rowids. |
UTLCONST.SQL |
Year 2000 compliance |
Any user |
Provides functions to validate that CHECK constraints on date columns are year 2000 compliant |
UTLDTREE.SQL |
Metadata management |
Any user |
Creates tables and views that show dependencies between objects |
UTLEXPT1.SQL |
Constraints |
Any user |
For use with Oracle8i. Creates the default table (EXCEPTIONS) for storing exceptions from enabling constraints. Can handle both physical and logical rowids. |
UTLHTTP.SQL |
Web access |
SYS or SYSDBA |
PL/SQL package to retrieve data from Internet or intranet web servers via HTTP protocol |
UTLIP.SQL |
PL/SQL |
SYS |
Used primarily for migration, upgrade, and downgrade operations. It invalidates all existing PL/SQL modules by altering certain dictionary tables so that subsequent recompilations will occur in the format required by the database. It also reloads the packages STANDARD and DBMS_STANDARD, which are necessary for any PL/SQL compilations. |
UTLIRP.SQL |
PL/SQL |
SYS |
Used to change from 32-bit to 64-bit word size or vice versa. This script recompiles existing PL/SQL modules in the format required by the new database. It first alters some data dictionary tables. Then it reloads the packages STANDARD and DBMS_STANDARD, which are necessary for using PL/SQL. Finally, it triggers a recompilation of all PL/SQL modules, such as packages, procedures, and types. |
UTLLOCKT.SQL |
Performance monitoring |
SYS or SYSDBA |
Displays a lock wait-for graph, in tree structure format |
UTLPG.SQL |
Data conversion |
SYS or SYSDBA |
Provides a package that converts IBM/370 VS COBOL II |
UTLPWDMG.SQL |
Security |
SYS or SYSDBA |
Creates PL/SQL function for default password complexity verification. Sets the default password profile parameters and enables password management features. |
UTLRP.SQL |
PL/SQL |
SYS |
Recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, and types. |
UTLSAMPL.SQL |
Examples |
SYS or any user with DBA role |
Creates sample tables, such as EMP and DEPT, and users, such as SCOTT |
UTLSCLN.SQL |
Advanced Replication |
Any user |
Copies a snapshot schema from another snapshot site |
UTLTKPROF.SQL |
Performance management |
SYS |
Creates the TKPROFER role to allow the TKPROF profiling utility to be run by non-DBA users |
UTLVALID.SQL |
Partitioned tables |
Any user |
Creates table required for storing output of ANALYZE TABLE ...VALIDATE STRUCTURE of a partitioned table |
UTLXPLAN.SQL |
Performance management |
Any user |
Creates the table PLAN_TABLE, which holds output from the EXPLAIN PLAN command |