A Practical Guide for Oracle DBAs Indexes play a critical role in Oracle database performance. While well-designed indexes can dramatically improve query response time, unused or missing indexes can just…
Read MoreA Practical Guide for DBAs Auditing helps Oracle DBAs track who did what, when, and from where. Whether for security reviews, compliance, or incident investigations, having ready-to-use audit queries saves…
Read MoreDetailed Description: The compile_invalid_objects.sh script is designed to automate the identification and compilation of invalid objects across pluggable databases (PDBs) within an Oracle multitenant database environment. Invalid objects—such as packages,…
Read MoreDetailed Description: This Bash script automates the enumeration and dynamic selection of Pluggable Databases (PDBs) in an Oracle Multitenant environment. It connects to the Oracle Container Database (CDB) as a…
Read MoreData Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…
Read MoreWhat is a Redo log corruption? In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists…
Read MoreIntroduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to download the database backup from OCI…
Read MoreIntroduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to Upload the database backup files from…
Read MoreSteps to upgrade the latest JDK in OEM agent : 1. Check JDK Version. Go to OEM agent location and check the java version. cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0/jdk/bin ./java -version 4. Upgrade…
Read MoreSteps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp p33355570_135000_Generic.zip /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 unzip…
Read More