Other Useful Reports

 < 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.

Table 12.4: Alphabetic Listing of Barbara Mathews' Programs

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 > 



Oracle 11i E-Business Suite from the front lines
Oracle 11i E-Business Suite from the Front Lines
ISBN: 0849318610
EAN: 2147483647
Year: 2004
Pages: 122

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net