Identify versions of components in EBS
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…
Read MoreSmart Flash in Oracle Exadata
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 online transaction processing…
Read MoreSmart Scans in Oracle Exadata
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 performance…
Read MoreSTEPS TO INSTALL SQLSERVER IN WINDOWS 10
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…
Read MoreMETABASE INSTALLING IN ORACLE DATABASE
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…
Read MoreFeature Oracle Database 12c, 19c, 21c
Feature Oracle Database 12c, 19c, 21c Introduction: Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is…
Read MoreQuery to get inactive count as per machine name and sql id
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 status=’INACTIVE’ and machine like ‘%servername%’ HAVING COUNT(prev_sql_id)>5 GROUP BY prev_sql_id,sql_text…
Read MoreORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV] [ADDR:0x444C5E6E0] [PC:0x117171614] [Application data integrity precise] [3]
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…
Read Morewhat is psudocolumn, Rowdepandancy and Norowdepandency in oracle
what is psudocolumn, Rowdepandancy and Norowdepandency in oracle A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you…
Read MoreSQL DBA: Backups
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…
Read More