$ORACLE_HOME/rdbms/admin |
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 |
ashrpt.sql |
Active Session History (ASH) report |
ashrpti.sql |
Active Session History (ASH) report |
awrblmig.sql |
AWR Baseline Migration |
awrddinp.sql |
Retrieves dbid,eid,filename for SWRF and ADDM Reports |
awrddrpt.sql |
Produces Workload Repository Compare Periods Report |
awrextr.sql |
Helps users extract data from the AWR |
awrinfo.sql |
Outputs general Automatic Workload Repository (AWR) information such as the size
and data distribution |
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 |
catalog.sql |
Builds the data dictionary views |
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. |
catrman.sql |
Creates recovery manager tables and views |
dbmshptab.sql |
Permanent structures supporting DBMS_HPROF hierarchical profiler |
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. |
dumpdian.sql |
Allows one to dump Diana out of a database in a human-readable format |
hangdiag.sql |
Hang diagnosis script |
soctt.sql |
Creates the SCOTT schema objects
and loads the data |
secconf.sql |
Secure configuration script |
spauto.sql |
SQL*PLUS command file to automate the collection of STATPACK statistics. |
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. |
utldtree.sql |
Shows objects recursively dependent on given object. |
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. |
utllockt.sql |
Prints the sessions in the system that are waiting for
locks, and the locks they are waiting for. |
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 on either automatically or deliberately. |
utlpwdmg.sql |
Creates the default Profile password VERIFY_FUNCTION. |
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 |
utltscln.sql |
Copies a snapshot schema from another snapshot site |
utlvalid.sql
|
Creates the default table for storing the output of the analyze
validate command on a partitioned table |
utlxmv.sql |
Creates the MV_CAPABILITIES_TABLE for DBMS_MVIEW.EXPLAIN_MVIEW. |
utlxplan.sql |
Builds PLAN_TABLE: Required for Explain Plan, DBMS_XPLAN, and
AUTOTRACE (replaced by catplan.sql) |
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 |
xdbvlo.sql |
Validates XML DB schema objects |
|
$ORACLE_HOME/sqlplus/admin |
glogin.sql |
SQL*Plus global login "site profile" file. Add any SQL*Plus commands here that are to be
executed when a user starts SQL*Plus, or uses the SQL*Plus CONNECT command. |
plustrce.sql |
Creates the PLUSTRACE role
required to use AUTOTRACE |
pupbld.sql |
Creates PRODUCT_USER_PROFILE |
|
$ORACLE_HOME/sysman/admin/scripts/db |
dfltaccpwd.sql |
Checks for default accounts with
default passwords |
hanganalyze.sql |
Hang analysis script for
stand-alone databases |
hanganalyzerac.sql |
Hang analysis script for RAC
clusters |