Oracle Database Administration, Oracle Developer Suite, Oracle JDeveloper, Oracle BI Publisher, Oracle Forms/Reports,Oracle SQL Developer

Data Center Consolidation

Data center consolidation is the process of reducing the volume of physical IT assets through highly efficient and scalable technologies. Organizations leverage data center consolidation to reduce operating costs.

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...