Ora Training Blog

Previous: Install Fusion Applications Provisioning Framework Fusion Applications 11.1.5 ships with Oracle 11g (11.2.0.3.0) database. You can either install it saperately (if you want to install RAC database) or use Fusion provisioning Wizard to create one.  To install Applications Transactional Database we need to run Oracle Fusion Applications Provisioning Wizard from <framework_location>/provisioning/bin <framework_location> is same where we installed the […]

Oracle SQL Tuning Tips consideration when writing an SQL statement is that it returns a correct result. The second is that it be the most efficient for a given situation.  You can use many different SQL statements to achieve the same result. It is often the case that only one statement will be the most […]

/*+ 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 […]