Archives
-
Oracle Applications Concurrent Request phase codes and status codes
Table Name: FND_CONCURRENT_REQUESTS Column Name: PHASE_CODE Value Meaning C Completed I Inactive P Pending R Running Table Name: FND_CONCURRENT_REQUESTS Column Name: STATUS_CODE Value Meaning D Cancelled U Disabled E Error M No Manager R Normal I Normal C Normal H On Hold W Paused B Resuming P Scheduled Q Standby S […]
Apr 3rd, 2009 | Filed under Concurrent manager, Oracle, Oracle Applications, Oracle Applications DBA -
Oracle SQL hints
/*+ 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 […]
Apr 2nd, 2009 | Filed under Applications Performance Tuning, Database Performance Tuning, Oracle, Oracle DBA -
Certified Oracle RAC Scenarios for Oralce eBusiness suite cloning
(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 […]
Apr 2nd, 2009 | Filed under Cloning Oracle Applications, Oracle, Oracle Applications, Oracle Applications DBA, Oracle Database cloningTags: 11i, certified, clone, cloning, Oracle, oracle applications, R12, RAC, rapid clone, rapidclone, release 12, scenarios
Recent Comments