Oracle Applications has useful collection of ready SQL scripts under $AD_TOP/sql. The following list shows the description of each script. For more details like if a specific script is available on a specific Apps version you need to check metalink note 108207.1 you will find the script and its description below.
adcompsc.pls
Compile objects in a given schema
adcpresp.sql
The script duplicates rows in FND_RESPONSIBILITY in the following way: Find data_group_id dg_id for the given data_group_name. For each row with data_group_id 0 in FND_RESPONSIBILITY, look for a corresponding row with data_group_id dg_id, with the same application_id, and responsibility_name that only differs in the given suffix string suffix_string. If such a row does not exist for the data_group_id dg_id, insert it.
aderrch2.sql
Reports all compilation errors for a given schema.
aderrchk.sql
Same as aderrch2.sql plus it fails if there are any errors
adtresp.sql
A fix for customers who have more than one set of books and they installed languages other than AMERICAN English. The symptom of the bug is that responsibility names are not translated properly for non-Standard data groups.
adutcobj.sql
Count objects by object type in schema
adutconf.sql
Utility script to display configuration of Applications
adutfip.sql
Utility script to display worker information
adutfpd.sql
Utility script to display product dependency information
ADXANLYZ.sql
Analyze all tables in an ORACLE ID with estimate sample 20%
ADXCKPIN.sql
Query the shared_pool area to determine space used by PL/SQL objects and whether they have been pinned.
ADXGNPIN.sql
Creates and runs a "pin" script for all packages and functions in a give schema
ADXGNPNS.sql
Creates and runs a "pin" script for all sequences in a give schema
ADXINMAI.sql
Install tables and views used by the Applications*DBA sql scripts.
adxirc.sql
AD - index - report columns
ADXLMCBC.sql
Live Monitor, Categorize Block Contention
ADXLMLSO.sql
Live Monitor, List Session Objects
ADXLMQMS.sql
Live Monitor, Query Monitor Statistics
ADXLPFLS.sql
Lock Problem, Find Lock Source
ADXLPSLU.sql
Lock Problem, Show Lock Users
adxpriv7.sql
grant privileges to a user
ADXRCSDC.sql
Report Configuration, Show Database Configuration formerly, config.sql (rollback, tablespace, data files)
ADXRCSTG.sql
Report Configuration, Select Table Grants
ADXRSEBH.sql
Estimate the effect of a bigger SGA cache on cache hit rate.
ADXRSESH.sql
Estimate the effect of a smaller SGA cache on cache hit rate.
ADXRSFIS.sql
Find the size (blocks, extents, extpct) of the given index.
ADXRSFTS.sql
Find the size (blocks, extents, extpct) of the given table.
ADXRSFUA.sql
Report the number of blocks used and the number of extents used for every table or index in every user in the database.
ADXRSLFS.sql
Report free extents in each tablespace.
ADXRSQDP.sql
Check for cache effectiveness for dc_xxxxx parameters' values.
ADXRSRTS.sql
Produce a brief database used space report.
ADXRSSIE.sql
Generate a list of tables and indexes whose next extent to be grabbed would be too large to be allocated in their corresponding tablespaces.
ADXRSSMF.sql
List tables and indexes with a number of allocated extents close to their max_extents.
ADXRSSMS.sql
Find space used for one's own segments.
ADXRSSRS.sql
Show v$rollstat statistics.
ADXRSSSU.sql
For a username, report the number of blocks used and the number of extents used for every table or index in that username.
ADXRSSTF.sql
Produce a brief report of database fragmentation by tablespace.
ADXRSSUS.sql
Report how much space each user has.
ADXUPLUP.sql
Generate a list of processes which the given user (NOT the database account's username) owns.
ADXUPSRU.sql
Show all users that have active transactions per Rollback Segment that they are writing to.
