Tags
Thursday, December 28, 2017
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...
Monday, December 18, 2017
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...
Monday, December 4, 2017
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...