Readily available Oralce apps SQL scripts under $AD_TOP/sql

Oracle Applications SQL scripts

Oracle Applications has useful collection of ready SQL scripts under $AD_TOP/sql. The following list shows the description of each script. For more details like if a specific script is available on a specific Apps version you need to check metalink note 108207.1 you will find the script and its description below.

How to clone the Oracle database software

This blog post describes the process of cloning an Oracle Home - in this case we are cloning a 11g Release 2 Oracle Home from source machine devastator to target machine vixen.

On source (devastator)

ORACLE_HOME location is : /u01/app/oracle/product/11.2.0/dbhome_1

Go to directory on source machine one level higher and tar the db_home1 directory and all sub-directories

Tuning Oracle Database Basics

1       Introduction

Purpose

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance.