The article explains how Copy Data Virtualization technology, exemplified by Actifio, consolidates Oracle and VMware data backup, disaster recovery, and development testing into a single platform, reducing production load, storage costs, and recovery time while providing incremental, always‑on data copies.
In this detailed DBA case study, the speaker explains how improper settings of Oracle's parallel execution parameters on an AIX‑based 10gR2 database led to process saturation, undo‑related wait events, and temporary connection issues, and describes the step‑by‑step diagnosis, parameter adjustments, and lessons learned for future tuning.
This article explains how Oracle wait events, especially latch contention such as cache buffers chains and LRU chain latches, reveal performance bottlenecks, and provides step‑by‑step methods, diagnostic tools, SQL examples, and tuning recommendations to locate and resolve database hotspots.
A community discussion weighs the benefits and drawbacks of upgrading Oracle 10gR2 to 11g, sharing real‑world experiences, technical pitfalls like ORA‑24247, alternative viewpoints, and guidance for DBAs deciding whether the upgrade is worth the effort.
This article presents a detailed case study of an Oracle RAC system performance bottleneck, walks through comprehensive monitoring, storage and partitioning analysis, and outlines a step‑by‑step optimization plan—including KEEP pool tuning and partition redesign—that dramatically improved I/O latency and overall throughput.
This article explains how Oracle's Cost‑Based Optimizer estimates the selectivity of range predicates without histograms, demonstrates calculations with sample data, shows PL/SQL code for converting string values to internal numbers, and discusses pitfalls such as identical internal values causing cardinality errors, offering solutions like gathering histograms or using DATE columns.
An Oracle RAC 11g installation on AIX failed intermittent queries with ORA‑04030 errors, and a deep dive revealed that missing shell limits for the grid user capped process memory at 128 MB, causing PGA allocation failures despite ample system resources.
Expert DBAs discuss critical Oracle 11.2.0.4 parameters to watch before production, covering generic, performance, deprecated, and OS‑level settings for AIX and Linux, with concrete examples such as shared pool sub‑pools, mutex tuning, cursor thresholds, and real‑world incidents like streams_pool_size misconfiguration.
This article details how to use PXE to automatically provision three‑node Oracle 11gR2 RAC clusters on bare‑metal servers, covering network planning, PXE server setup with a one‑click installer, required software download, MAC address collection, shared‑disk and node configuration, virtual tape library setup, time synchronization, and user creation.
This article presents a detailed case study of diagnosing Oracle DBtime spikes using Zabbix, custom scripts, AWR and ASH analysis, revealing how scheduler jobs, materialized view refreshes, parallel execution, and unusable indexes caused performance jitter, and demonstrates step‑by‑step remediation to stabilize DBtime.
DD Boost integrates tightly with Oracle RMAN to provide a flexible, policy‑driven backup solution that allows DBAs to manage local and disaster‑recovery sites independently, simplifies deployment via a simple plugin, and dramatically improves performance by sending only unique data blocks to Data Domain for deduplication.
During a lively Q&A session organized by the ‘Efficient Operations’ community, Oracle InnoDB principal developer Lai Zheng and Microsoft SQL Server product manager Lin Mo discuss SQL Server’s operational advantages over other databases, Microsoft’s product roadmap, common maintenance challenges, and the ideal career path for a modern DBA.
In a lively Q&A session, Oracle experts discuss how China’s “post‑IOE” shift, cloud migration, big‑data collaboration with Hadoop, and the strengths of In‑Memory, TimesTen, and Exadata shape the future direction of Oracle databases.
This article examines the technical, managerial, and cost challenges telecom operators face when migrating from Oracle‑based IOE architectures to open‑source databases, offering practical insights, case studies, and recommendations for a successful transition.
Oracle stopped publishing public security patches and updates for Java 7 in April 2015, urging users to migrate to Java 8 or obtain long‑term commercial support, which has caused compatibility challenges for tools still relying on deprecated Java 7 features and prompted consideration of alternative JVMs.
This guide walks through essential Oracle database restore steps, from checking the current directory and copying dump files to restarting the service, managing users, creating directories, and importing data with impdp commands.
This article presents a comprehensive side‑by‑side mapping of 45 common SQL Server functions to their Oracle equivalents, covering numeric, string, date, and miscellaneous operations with example queries and notes on usage differences.
