Joords Oracle DBA blog

Oracle validated RPM Preparing Linux for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. See for more information   Oracle Enterprise Linux Archives  and The Oracle-Validated rpm is available for all users . Public Yum Server The Oracle public yum server offers a free and convenient way to install packages from the Enterprise Linux and Oracle VM installation media via a yum client. Read how to do this on Public Yum Server

Statspack cannot be executed on a standby Database due to its read-only nature therefore tuning the performance of the apply process involves manually collecting statistics. In the new Active Data Guard option, users can now use statspack from the primary database to collect data from a standby database that is opened read-only and performing recovery. The standby statspack is installed in a separate schema on the Primary database, STDBYPERF which is then propagated to the standby. This user "STDBYPERF" user does not have DBA privileges and has no access to local V$ tables.