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
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
For improving performance we need to move table to a different tablespace with higher block size. Higher blocksize increase the performance of select query tremendously. The following short article shows the process of creating the higher block tablespace and moving the table to it.