Useful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log in to the Application server and [...]

Smart Flash in Oracle Exadata In the realm of data management and high-performance computing, Oracle Exadata has established itself as a powerhouse, delivering exceptional capabilities for both [...]

Smart Scans in Oracle Exadata In the ever-evolving landscape of data management and analytics, businesses are continually searching for ways to extract more value from their data while optimizing [...]

STEP – 1 1 First download .netframework 3.5   Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the [...]

METABASE INSTALLING IN ORACLE DATABASE   Requirements – Metabase requires a Java Runtime Environment (JRE), with a Java version of 11 or higher. – Check you have a java version [...]

Please use the below query.     SELECT count(prev_sql_id),prev_sql_id,sql_text FROM v$session LEFT OUTER JOIN v$sql ON v$session.prev_sql_id = v$sql.sql_id WHERE [...]

Please find the below steps to resolve the same. ADI [Application Data Integrity] memory feature is enabled by default in Solaris SPARC Download and apply Patch 35464935. OR Set the follow [...]

Description: Copy of the database that is used to recover the data after the system failure. Backups are used as safeguards for databases because data may be lost due to Media failures, user [...]

        Adding data file to Mirroring database What is Mirroring? Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the [...]

                                  Inplace Upgradation Introduction: Upgradation involves overwriting existing SQL Server instance and upgrading from one version to another version.  Applying a [...]