CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Files
Version 11.1
 
$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
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [214 users online]    © 2010 psoug.org