Installation of Oracle Apps R12.2.x Step by Step guide

In this article, installation of R12.2.x has been shown with detail installation screen. This is a single node installation where database and apps will be installed in same server. This installation was done on a linux

Oracle data buffer tuning scripts

Here, I'll discuss two scripts which I use often to check the oracle data buffer performance.

How to analyze v$active_session_history table to find the wait events in oracle

v$active_session_history is a important table to find the wait events inside oracle. In this article we'll show to use this table to find following important information.

How to identify the timing when database parameters exceeding predefined threshold value

The following powerful script can be used to identify the timing when the oracle database is exceeding some

SYSAUX tablespace is growing erratically due to growth of WRI$_OPTSTAT_HISTHEAD_HISTORY table

This is a bug of oracle. If gather schema takes much time it doesn't complete the full operation and  WRI$_OPTSTAT_HISTHEAD_HISTORY keeps up growing. It exhausts the SYSAUX tablespace. Oracle recommends a patch to be applied to resolve the above problem. But, in our case there is some