| < Day Day Up > |
|
Barbara Matthews of OnCallDBA.com and author of Administering Oracle Applications has created many useful scripts and reports that can be found at http://www.oncalldba.com/scripts/TheBookScripts/. While most of these scripts were written against 10.7 or 11.0 versions of Oracle Applications, most are still applicable and highly useful with an 11.5.# environment. An alphabetic listing of some of the most useful ones and their descriptions can be found in Table 12.4.
Report/Script Name | Script | Description |
---|---|---|
Analyze SYS and System Objects with Delete Statistics | RMINC_delete_stat.sql | If you mistakenly analyzed sys or system objects, this will unanalyze them for you. |
Analyze Tables and Indexes | RMINC_run_stat.sql | Analyzes all tables and indexes not owned by sys or system (uses analyze not dbms_stats). There is also a concurrent job (a program called by a concurrent manager) that will do this for you. |
Coalesce Tablespaces | RMINC_run_coal.sql | Coalesces all tablespaces. |
Concurrent Manager Performance History | RMINC_mgrp.sql | Shows the performance history, broken out by Concurrent Manager. |
Concurrent Request History | RMINC_rpthis.sql | Shows the history of a Concurrent Program, including who ran it, how long it took, and which parameters were passed to it. |
Concurrent Request Performance History | RMINC_rptsump.sql | Shows performance history of all concurrent requests that have run since a user specified date. |
Concurrent Requests that Errored or Terminated | RMINC_concmgrerrors.sql | All terminated requests or requests that ran but errored out. |
Concurrent Programs by Request Type | RMINC_req_type_progs.sql | Shows Concurrent Programs by type of request. |
| < Day Day Up > |
|