Ora Training Blog

/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if […]

(Based on Oracle Metalink note: 783188.1 as on 3-Mar-2009) This document is divided into the following sections: Section 1: Terminology Section 2: Supported Scenarios Section 3: References The most up-to-date version of this document can be obtained in Note 783188.1. Section 1: Terminology Cloning an Oracle E-Business Suite system that uses an Oracle Real Application Clusters […]

Cloning creates an identical copy of an existing Oracle Applications system. There are various reasons for cloning an Oracle Applications system such as: Creating a copy of the production system for testing updates. Migrating an existing system to new hardware. Creating a stage area to reduce patching downtime. This document is based on Oracle Metalink […]