Automatic Memory Management (AMM) in Oracle Database 11g R2
Identify Memory Requirement.Following queries show you how to display the relevant memory information and how to combine with a single statement to calculate the required values.-- Individual values.COLUMN name FORMAT A30COLUMN value FORMAT A10SELECT name, valueFROM v$parameterWHERE name IN ('pga_aggregate_target', 'sga_target')UNIONSELECT...
Oracle FNDLOAD Scripts
FNDLOADTips and Examples Using FNDLOAD (Doc ID 735338.1) Download Script Upload Script 1. LookupsFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt...
Running ADOP Fails With Error "ETCC Not Run In The Database Node"
Error: ETCC not run in the database node [Node Name] The EBS Technology Codelevel Checker needs to be run on the database node. It is available as...