This guide explains the two main database career tracks—DBA (database administration) and database development—covers the challenges for fresh graduates, discusses certification value, and offers practical methods for mastering database theory and hands‑on skills.
This article demonstrates step‑by‑step how Oracle DBAs can identify the origin of recursive SQL statements by leveraging the 10046 trace at both SQL‑ID and session levels, analyzing the trace with the Orasrp tool, and ultimately pinpointing the PL/SQL function that generated the query.
This guide explains when and why Oracle statistics are needed, how to control automatic and manual collection, prevent out‑of‑range errors, boost efficiency with parallel and incremental methods, and handle special cases like volatile or temporary tables for optimal query performance.
This guide explains the most commonly used Oracle permission‑view tables, shows how to list role assignments, object privileges, system privileges, session privileges, and role memberships, and demonstrates the impact of the WITH ADMIN OPTION through practical SQL examples.
A developer discovers a nearly full 1 TB server disk caused by large SQL Server backup files, learns the backup strategy, removes old backups while keeping monthly snapshots, manually syncs production data to a test server, and reflects on backup file formats and storage optimization.
This article recounts a DBA’s personal journey preparing for and passing the Oracle OCP 051 certification, detailing study resources, hands‑on experiments, common Oracle errors, exam strategies, and lessons learned for future database learning.
This guide compiles a comprehensive set of MySQL learning materials—including introductory and advanced books, online courses, podcasts, and a curated toolbox of performance, monitoring, client, and migration utilities—helping aspiring DBAs build solid SQL skills and master MySQL operations.
This article explains how granting and revoking Oracle roles, especially the DBA role, affect permission activation timing, the immediate loss of UNLIMITED TABLESPACE rights, and practical steps to restore necessary tablespace access for application users.
The article explains why Oracle bad block incidents demand scenario‑driven handling, outlines interview questions, describes the pitfalls of inspecting each alert log, and advocates promptly switching to disaster‑recovery and using backups to restore service, while sharing real‑world cases and practical DBA advice.
This article, based on a 2016 Global Operations Conference talk, outlines Oracle DevOps best practices through SQL auditing, presenting multiple real‑world cases, derived rules, and automation strategies that help DBA and development teams identify performance bottlenecks, enforce standards, and improve system stability.
A DBA intern recounts a real‑world Oracle tablespace failure, the challenges of resizing a BIGFILE tablespace, disk‑space shortages, permission errors during data‑file migration, and the key lessons about communication, analysis, and preparation for future production incidents.
This article summarizes Gai Guoqiang's presentation on Oracle Database DevOps practices, covering Oracle's cloud strategy, the shifting competitive landscape, the impact of cloud on DBA roles, and how DevOps principles are reshaping traditional database operations and performance management.
This comprehensive guide explains Oracle's memory‑management evolution, compares manual SGA/PGA sizing with ASMM, AMM and PGA automatic management, details key parameters and hidden settings, shows how to size SGA, PGA and large pages, and offers practical best‑practice recommendations for DBAs.
This article explains how the Tencent Game DBA team uses Percona's pt-table-sync to detect and automatically repair MySQL replication inconsistencies, achieving up to 30‑fold speed improvements, reducing resource usage, and enabling a data self‑healing service for large‑scale gaming databases.
This guide explains Oracle's auditing capabilities, covering its purpose, three audit types, how to enable auditing via AUDIT_TRAIL, defining audit policies, controlling record generation, locating audit records, special considerations, and provides practical SQL examples.
The article explains how a seemingly harmless SQL statement, when executed millions of times on an IBM Power780 system with a 1 TB configuration, can overload the library cache mutex, causing the database to stall, and provides the original script, reproduction steps, and practical advice to avoid such catastrophic contention.
This article shares practical Oracle DBA experiences—including role definitions, environment considerations, monitoring strategies, performance‑tuning case studies, development‑business integration, and future‑oriented operations—offering concrete guidance and hard‑won insights for database administrators.
On February 10, 2016 a provincial accounting database experienced severe daily‑batch delays despite other applications running normally; a senior DBA collected alert logs, AWR snapshots, ASH dumps, and OSW metrics, uncovered log‑file‑sync and redo‑IO degradation, increased rollbacks, and a faulty SAN link, pinpointing the root cause.
This article explains how the OraZ toolset streamlines Oracle database administration by automating routine tasks, providing intelligent hang analysis, offering comprehensive health checks, and delivering real‑time instance activity insights, ultimately reducing DBA workload and improving operational efficiency.
This article presents a comprehensive guide to MySQL optimization, covering its strengths and weaknesses, daily DBA tasks, development and operational standards, sharding strategies, backup solutions, performance tuning, replication options, InnoDB configuration, system-level tweaks, and future improvement directions.
This guide outlines a structured MySQL DBA interview process, covering self‑introduction, resume deep‑dive, career‑development questions, fundamental knowledge such as index types, core technical skills like backup, replication and performance troubleshooting, and broader potential areas including Linux and programming language proficiency.
This comprehensive guide explains the concepts of database baselines and capacity management, outlines DBA skill levels, provides real‑world examples, details data collection methods, and offers actionable strategies for performance analysis, threshold setting, and automated monitoring.
This guide explains Oracle Real‑Time SQL Monitoring, covering terminology, activation conditions, how to access it via Enterprise Manager Cloud Control, and detailed walkthroughs of its various panels, metrics, and practical examples for diagnosing and optimizing long‑running queries and index builds.
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.
A DBA community debate examines whether developers should be allowed to touch production databases, weighing the dangers of unrestricted access against the need for troubleshooting, and outlines practical policies, approval processes, and separation‑of‑duty safeguards to protect data integrity.
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.
This article records the Q&A from Zhejiang Mobile’s Operations Forum, revealing how the company is progressing through its PostgreSQL migration, the technical pitfalls encountered, and practical advice on database refactoring, ecosystem building, and the economic impact of moving away from legacy Oracle systems.
In this interview, Liu Qiuqi shares his journey from a DBA at Sogou to Architecture Operations Director at BabyTree, revealing how MySQL powers massive e‑commerce and community sites, the high‑availability designs, storage strategies, and performance tuning techniques that keep services running smoothly.
In this interview, veteran Oracle DBA Shi Yuedong shares his career journey, personal philosophy on opportunity, a hands‑on performance‑diagnosis case at Lenovo, experiments revealing Oracle 12.1's default statistics sampling rate, and thoughtful perspectives on big data versus data‑warehouse evolution.
This guide shares a curated list of foundational books and resources for beginners aiming to master SQL, deepen MySQL expertise, and develop the operational and data‑centric mindset needed for a successful DBA career, including links to downloads and a weekly MySQL radio show.