Scripts in $AD_TOP/sql

$AD_TOP/sql 下有许多非常有用的脚本。

Script	11.0.x	10.7NCA	10.7SC/16.1	Description
adcompsc.pls	x	x	x	Compile objects in a given schema
adcpresp.sql	x			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 fora 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	x	x	x	Reports all compilation errorsfor a given schema.
aderrchk.sql	x	x	x	Same as aderrch2.sql plus itfails if there are any errors
adtresp.sql	x			A fix for customers who havemore than one set of books and they installed languages other than AMERICANEnglish. The symptom of the bug is that responsibility names are not translatedproperly for non-Standard data groups.
adutcobj.sql	x	x	x	Count objects by object typein schema
adutconf.sql	x	x	x	Utility script to display configurationof Applications
adutfip.sql	x	x	x	Utility script to display workerinformation
adutfpd.sql	x	x	x	Utility script to display productdependency information
ADXANLYZ.sql	x	x	x	Analyze all tables in an ORACLEID with estimate sample 20%
ADXCKPIN.sql	x	x	x	Query the shared_pool area todetermine space used by PL/SQL objects and whether they have been pinned.
ADXGNPIN.sql	x	x	x	Creates and runs a "pin" scriptfor all packages and functions in a give schema
ADXGNPNS.sql	x	x	x	Creates and runs a "pin" scriptfor all sequences in a give schema
ADXINMAI.sql	x	x	x	Install tables and views usedby the Applications*DBA sql scripts.
adxirc.sql	x	x	x	AD - index - report columns
adxirn.sql	x	x	x	Drops and recreates an indexas nonunique.
ADXLMCBC.sql	x	x	x	Live Monitor, Categorize BlockContention
ADXLMLSO.sql	x	x	x	Live Monitor, List Session Objects
ADXLMQMS.sql	x	x	x	Live Monitor, Query Monitor Statistics
ADXLPFLS.sql	x	x	x	Lock Problem, Find Lock Source
ADXLPSLU.sql	x	x	x	Lock Problem, Show Lock Users
adxpriv7.sql	x	x	x	grant privileges to a user
ADXRCSDC.sql	x	x	x	Report Configuration, Show DatabaseConfiguration formerly, config.sql (rollback, tablespace, data files)
ADXRCSTG.sql	x	x	x	Report Configuration, SelectTable Grants
adxrfmi.sql	x	x	x	report installed modules fromfnd_module_installations
adxrfpi.sql	x	x	x	report rows from fnd_product_installationsand related tables
ADXRSEBH.sql	x	x	x	Estimate the effect of a biggerSGA cache on cache hit rate.
ADXRSESH.sql	x	x	x	Estimate the effect of a smallerSGA cache on cache hit rate.
ADXRSFIS.sql	x	x	x	Find the size (blocks, extents,extpct) of the given index.
ADXRSFTS.sql	x	x	x	Find the size (blocks, extents,extpct) of the given table.
ADXRSFUA.sql	x	x	x	Report the number of blocks usedand the number of extents used for every table or index in every user inthe database.
ADXRSLFS.sql	x	x	x	Report free extents in each tablespace.
ADXRSQDP.sql	x	x	x	Check for cache effectivenessfor dc_xxxxx parameters' values.
ADXRSRTS.sql	x	x	x	Produce a brief database usedspace report.
ADXRSSIE.sql	x	x	x	Generate a list of tables andindexes whose next extent to be grabbed would be too large to be allocatedin their corresponding tablespaces.
ADXRSSMF.sql	x	x	x	List tables and indexes witha number of allocated extents close to their max_extents.
ADXRSSMS.sql	x	x	x	Find space used for one's ownsegments.
ADXRSSRS.sql	x	x	x	Show v$rollstat statistics.
ADXRSSSU.sql	x	x	x	For a username, report the numberof blocks used and the number of extents used for every table or indexin that username.
ADXRSSTF.sql	x	x	x	Produce a brief report of databasefragmentation by tablespace.
ADXRSSUS.sql	x	x	x	Report how much space each userhas.
ADXUPLUP.sql	x	x	x	Generate a list of processeswhich the given user (NOT the database account's username) owns.
ADXUPSRU.sql	x	x	x	Show all users that have activetransactions per Rollback Segment that they are writing to.
applcrt.sql		x	x	Modified CRT definitions forApplications Environment

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22816976/viewspace-2126039/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22816976/viewspace-2126039/