ORATraining Blog

Table Name: FND_CONCURRENT_REQUESTS

Column Name: PHASE_CODE
 

 
Table Name: FND_CONCURRENT_REQUESTS

Column Name: STATUS_CODE
 

/*+ 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 alias names are used for table names. So the following is wrong:

select /*+ index(scott.emp ix_emp) */ from scott.emp emp_alias

better:

select /*+ index(emp_alias ix_emp) */ … from scott.emp emp_alias

Why using hints

Read more…

(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 (Oracle RAC) enabled database involves numerous different technology components and steps, and would therefore be a complex, error-prone process if carried out manually.

To speed up, simplify, and enhance reliability of the process, Oracle offers the following tools for use in cloning RAC Enabled Oracle E-Business Suite systems:

• Rapid Clone – Command-line tool
• Oracle Application Management Pack for Oracle E-Business Suite (AMP) – GUI-based tool used for automated end-to-end cloning

This document provides details of the RAC scenarios that are currently certified for cloning using these tools. Other scenarios are planned as shown.

Note: Scenarios not shown are not supported.

Read more…

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 document 230672.1 (cloning an Oracle Applications Release 11i system).

• Section 1: Prerequisites
  Tasks to perform before using Rapid Clone.
• Section 2: Clone Oracle Applications 11i
  Tasks to prepare, copy, configure, and verify a cloned Applications System.
• Section 3: Finishing Tasks
  Tasks to complete the cloning process.
• Section 4: Advanced Cloning Methods
  Tasks for advanced options such as refreshing and multi-node cloning.

Read more…

Installing Oracle Applications on RedHat Linux 4.0