SQL provides powerful extensions to GROUP BY: ROLLUP and CUBE. These are extremely useful for building reports with subtotals and cross-tab summaries. Let’s see some practical examples. Example 1: Total Salaries with ROLLUP by Department and Job This query calculates total salaries: Output: The hierarchy is clear: job totals roll up into department totals, which […]
When a performance issue occurs in Oracle Cloud Infrastructure (OCI), the Cloud Ops DBA’s job is not just to react but to diagnose systematically and resolve the root cause. Performance problems may stem from compute, storage, network, database configuration, or inefficient SQL. This blog provides a step-by-step deep dive troubleshooting workflow with OCI CLI commands, […]
Performance issues in Oracle Cloud Infrastructure (OCI) databases can arise due to CPU saturation, I/O bottlenecks, long-running queries, or inefficient application design. As a Cloud Ops DBA, your role is to identify the root cause quickly and take corrective actions. This guide walks through a structured troubleshooting approach using both OCI CLI and Oracle dynamic […]
Troubleshooting with OCI CLI: Practical Examples 1. Checking Database System Status When users complain about slow connections or failures, the first step is to verify if the DB system is healthy. Sample Output Interpretation: 2. Checking Database Instance Health Sample Output Interpretation: 3. Checking Recent Database Backups When a backup job fails, confirm the backup […]