Oracle Application Performance Tuning Scripts

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance.

One should do performance tuning for the following reasons:

* The speed of computing might be wasting valuable human time (users waiting for response);
* Enable your system to keep-up with the speed business is conducted; and
* Optimize hardware usage to save money (companies are spending millions on hardware).

Here are the oracle performance tuning scripts used in oracle applications.
I will be adding more information about this scripts soon

Remember: They are used in oracle applications 11i version.

active.sql
afimmethod.sql
alter_tbs.sql
analyzepending.sql
analyzereq.sql
appproc.sql
apps_alerts.sql
appsi1.sql
appsid.sql
appuser.sql
appusers.sql
aps_lock.sql
archlogs.sql
badge.sql
bbwfiles.sql
bbwsid.sql
bcfootprint.sql
bde_chk_cbo.sql
bigtemptabs.sql
bigtsobj.sql
ccmospid.sql
ckactmt.sql
ckfsstat.sql
ckhwm.sql
ckiostat.sql
ckkept.sql
cklibcache.sql
ckmodules.sql
ckmt.sql
cknotkeptdet.sql
ckobj.sql
ckobjstats.sql
ckownerstats.sql
ckrbs.sql
cktempts.sql
cktsdf.sql
ckufs.sql
ckurbs.sql
cmadmin.sql
cmclean.sql
cmdailylongj.sql
cmdailylong.sql
cmlong.sql
cmpending.sql
cmpend.sql
cmqhourly.sql
cmqjobs.sql
cmqrdet.sql
cmqrtimes.sql
cmquickq.sql
cmqwdet.sql
cmqwtimes.sql
cmreq.sql
cmrun.sql
cmtoday.sql
coe_stats.sql
count_md_recs.sql
dbms_lock_allocated.sql
dbsize.sql
explain_s2.sql
explain_s.sql
fbwsid.sql
fix_invflag.sql
formid.sql
formuser.sql
frag2.sql
fragmentation.sql
free_space.sql
fts.sql
getplsqldef.sql
hashopensql.sql
hashsql.sql
hashstats.sql
hotbkupstat.sql
hotblocks.sql
hotobjects.sql
inactive.sql
index.sql
initora.sql
inv_obj.sql
iowaitsdf.sql
jobhistdet.sql
jobhist.sql
jobid.sql
kgl_mod3.sql
kgl.sql
killcmreq.sql
last10jobs.sql
last10userjobs.sql
last_run_date.sql
lclholder.sql
lholder.sql
locksumm.sql
lock_wait1.sql
lock_waits.sql
logstatus.sql
longops.sql
long_run.sql
lsleep.sql
lwait.sql
maxdfrdtm.sql
maxwaits.sql
modopensql.sql
mtptdf.sql
mtpt.sql
newblockers.sql
newses.sql
newwaiters.sql
notextend.sql
object.sql
objlocks.sql
objs_in_cache.sql
osproc.sql
parttabinfo.sql
perftest_forms2.sql
perftest_forms.sql
perftest_logins.sql
po_reapprove.sql
pxbuffers.sql
pxiostats.sql
pxprocs.sql
pxsession.sql
pxslave.sql
pxsorts.sql
pxstats.sql
qcsid.sql
realname.sql
recentses.sql
recompile_sql.sql
redo.sql
redostats.sql
retry_all_invoice.sql
retry_wf_500.sql
retry_wf.sql
rolesgrants.sql
segactivity.sql
sesswork.sql
sidevents.sql
sidlock.sql
sidlongops.sql
sidopensql.sql
sidsort.sql
sid.sql
sidsql.sql
sidtime.sql
sidwait.sql
sidwaits.sql
sorttypes.sql
sparse_indexes.sql
sparse_tables.sql
spexecs.sql


temp_alert.sql
temp_conc_prog.sql
test1.sql
top10active.sql
top10active.sql.bak
top10cpu.sql
top10extents.sql
top10hogs.sql
top10inactive.sql
top10jobs.sql
top10opencurs.sql
top10seswaits.sql
top10sorts.sql
top10spid.sql
top10sysevents.sql
topreaddf.sql
topwritedf.sql
tsbufhit.sql
tsdcmrat.sql
tslcmrat.sql
tstsid.sql
tst.sql
tsusage.sql
waits_alerts.sql
waits.sql
webmethods_work.sql
whereami.sql
whosort.sql