Performence Tuning Scripts List

All related COE, BDE, TRCA, SQLT and PROF scripts can be downloaded from MetaLink or directly from Oracle's external FTP server

ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE

MetaLink
Script from FTP server
Title

224270.1
TRCANLZR.SQL
Trace Analyzer (8.1.6+)

215187.1
SQLTXPLAIN.SQL
Enhanced Explain Plan and related info for one SQL statement (8.1+)

243755.1
profiler.sql
Implementing and Using the PL/SQL Profiler (8.1+)

156959.1
coe_xplain_80.sql
Enhanced Explain Plan for given SQL Statement (8.0)

156960.1
coe_xplain_73.sql
Enhanced Explain Plan for given SQL Statement (7.3)

174603.1
bde_x.sql
Simple Explain Plan for given SQL Statement (8.1+)

156972.1
coe_view.sql
Clones views across instances for SQL tuning exercises (8.0+)

238684.1
SQLAREAT.SQL
Top 10 Expensive SQL from SQL Area (8.1+)

163209.1
coe_sqlarea_80.sql
Top 10 Expensive SQL from SQL Area (8.0)

169630.1
bde_session.sql
Expensive SQL and resources utilization for given Session ID (8.1+)

174605.1
bde_chk_cbo.sql
Current, required and recommended Apps 11i init.ora params (11i)

163208.1
bde_last_analyzed.sql
Verifies Statistics for all installed Apps modules (11i)

156968.1
coe_stats.sql
Automates CBO Stats Gathering using FND_STATS and Table sizes (11i)

156969.1
coe_trace.sql
SQL Tracing Apps online transactions with Event 10046 (11i)

156970.1
coe_trace_11.sql
SQL Tracing Apps online transactions with Event 10046 (11.0)

156971.1
coe_trace_all.sql
Turns SQL Trace ON for all open DB Sessions (8.0+)

156965.1
coe_locks.sql
Session and serial# for locked Rows (7.3+)


Templates
MetaLink
Apps Performance Bug Template

169937.1
Transaction Tuning

169938.1
Back-End Tuning

169939.1
Tech-Stack Tuning