DBA Yin Haiwen details how Chuanxu evolved from an Agent memory system into a database-backed control plane enforcing identity, permissions, and audit trails across Oracle, PostgreSQL, and YashanDB, using a seven-layer dependency chain and fail-closed zero-trust model.
A comprehensive reference of 100 production-ready SQL queries for monitoring, troubleshooting, and managing Oracle 19c Active Data Guard environments, covering configuration, synchronization, role transitions, performance, and daily maintenance with risk annotations.
This article details a five-phase migration process for China's Xinchuang database replacements, covering Oracle-to-Dameng and MySQL-to-Kingbase routes, compatibility mode selection, schema conversion, data migration, application refactoring, regression verification, and critical dialect pitfalls like auto-increment, upsert, date functions, and empty-string handling.
Oracle founder Larry Ellison established then withdrew a 10b5-1 plan to sell up to 50 million shares worth ~$7.5B, a move that highlighted tensions between U.S. insider-trading safe harbors and EU blackout rules, while Oracle's AI-driven cloud growth, rising debt, and Ellison's personal financing commitments for his son's media deals added pressure on the stock.
OpenJDK’s new interim policy bans any contribution generated by large language models, citing intellectual‑property risks, reviewer burden, and the critical safety role of the JDK, while Oracle simultaneously embraces AI internally, highlighting a stark double standard across the open‑source ecosystem.
The article examines OpenJDK’s new interim policy that outright bans any AI‑generated contributions, explains the underlying concerns about reviewer workload, safety, and intellectual‑property risks, contrasts Oracle’s internal AI adoption with its open‑source stance, and surveys how other major projects handle AI‑assisted code.
The author recounts a client visit where, after previous unsatisfactory AI deployments, they analyze the client’s existing database schemas, use the OntoL ontology platform together with the Qianwen large‑language model to generate a semantic model for project‑contract‑payment queries, approval tracking, and risk identification, configuring an Oracle data source and customizing DSL functions to enable interactive analysis.
Oracle’s 2026 layoffs hit the MySQL team, community contributions fell 44% since 2017, while PostgreSQL climbs, and SQLite—once dismissed as a toy—now powers billions of devices and edge‑computing platforms, boosted by projects like LibSQL, Turso, Cloudflare D1 and Litestream, offering latency advantages over traditional servers.
A recent Huntress investigation reveals how attackers leveraged a web‑app SQL injection to compile the khunt tool as internal Java objects in an Oracle database, then used those objects to execute commands, steal credentials and obtain Windows SYSTEM privileges, highlighting the stealth of in‑database backdoors.
Oracle has prohibited any AI‑generated contributions to OpenJDK, citing security, review burden, and IP risks, while simultaneously betting billions on internal AI development, cutting staff, and facing credit‑rating downgrades, sparking a paradox that the tech community and investors are closely watching.
The article analyzes SAP’s tight budgeting and ecosystem opening alongside Oracle’s massive AI‑infrastructure gamble, showing how both strategies reflect AI‑driven market pressure, risk‑laden shifts in business models, and the accelerating demise of the traditional high‑margin enterprise‑software era.
In a candid interview, PostgreSQL founder Michael Stonebraker recounts his journey from Ingres to Postgres, critiques Oracle’s sales tactics, denounces Google’s and Amazon’s database strategies, explains Postgres’s extensible type system, explores the DBOS research project, and highlights why current large‑language‑model‑to‑SQL solutions remain far from production‑ready.
This article examines three open‑source projects—TradingView MCP, Oracle, and kordoc—that use AI to bridge isolated finance tools, enabling automated chart analysis, AI‑assisted code review, and universal Korean document parsing within a unified financial data workflow.
The article argues that domestic databases are far from a joke, highlighting how building a database touches virtually every computer‑science discipline, and recounts Oracle’s early versions—lacking transactions, constraints, and reliable locking—to illustrate the long path from primitive systems to mature, world‑class databases.
Oracle announced that starting with JDK 27 it will cease maintaining the macOS/x64 Java runtime, citing Apple Silicon dominance and engineering costs, and the article examines the broader ecosystem shift, enterprise impact, and mitigation options for developers still on Intel Macs.
Oracle announced a new open‑source governance plan for MySQL, but developers, cloud providers, and third‑party vendors remain skeptical, demanding legally binding guarantees, fearing short‑term fixes, potential forks, and a shift of talent toward PostgreSQL.
Oracle’s 2026 10‑K filing discloses that AI adoption prompted the company to eliminate about 21,000 employees—roughly 13% of its global workforce—incurring $1.84 billion in severance, while simultaneously investing heavily in AI data‑center infrastructure, highlighting a strategic shift and raising concerns about reliance on a few large AI customers.
The article analyzes the write bottleneck of processing 30,000 payment orders per second on an Oracle‑Java‑Spring stack, explains why sharding was used historically, why MQ‑based peak‑shaving is discouraged, and compares self‑built sharding with modern distributed databases such as PolarDB‑X, TiDB and OceanBase, while summarizing public practices from major Chinese tech firms.
This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.
This guide outlines step‑by‑step procedures for diagnosing Oracle database performance problems, covering how to collect ADDM, AWR, and ASH reports, capture high‑CPU error stacks, obtain 10046 trace files for single or multiple sessions, and use Oracle hang‑analysis documents to differentiate true hangs from CPU spinning.
Oracle has open‑sourced its Skills repository on GitHub, providing over 100 curated, version‑compatible guides for Oracle Database, OCI, GraalVM, Fusion and APEX, and defining a new AI‑centric “Skill” abstraction that lets agents safely generate and execute database operations, heralding a Skill‑driven AI engineering era.
The article walks through Oracle response‑time analysis, compares service and wait time, presents two real‑world cases (Statspack pre‑10g and AWR post‑10g) that show I/O waits often contribute less than 6% of total time, and then details step‑by‑step methods, parameters, and storage techniques for diagnosing and reducing I/O‑related performance problems.
Oracle is expanding its partnership with Bloom Energy to install a 2.45 GW fuel‑cell power plant near a new desert data‑center complex in New Mexico, positioning the move as a greener alternative to its earlier gas‑diesel "Jupiter" plan despite reliance on natural‑gas‑based fuel cells.
A Gartner revenue‑based DBMS market share chart shows Oracle slipping from the top while cloud giants and fast‑growing newcomers like Snowflake, Databricks and CockroachDB gain ground, and DB‑Engines rankings reveal PostgreSQL’s rise and Oracle’s gradual decline despite still leading overall.
This article documents a complete penetration test on a newly deployed environment, detailing how weak credentials, unauthenticated services, and misconfigurations in MSSQL, Nacos, Oracle, Telnet, OA, NC, Redis, Spring, and frontend assets were systematically discovered and exploited, with step‑by‑step screenshots illustrating each compromise.
The article explains how Oracle, Spring, and JetBrains are collectively pushing Java toward an agent‑centric ecosystem, shifting the developer’s role from writing code to orchestrating AI agents, and outlines the specific capabilities, engineering practices, and risks Java engineers must adopt to stay competitive in the coming years.
Oracle has notified thousands of employees of a massive layoff, projecting up to 30,000 job cuts—about 18.5% of its workforce—as the company ramps up AI data‑center spending, a trend echoed by other U.S. tech giants facing AI‑induced restructuring.
Oracle’s 2026 AI database rollout fuses vector search, private AI agents, unified memory, and deep data security directly into the database engine, challenging the cloud‑centric data‑movement paradigm and prompting a market shift that could revive Oracle’s dominance while reshaping strategies for DBAs, AI engineers, and decision makers.
Oracle announced the GA release of Java 26/JDK 26, detailing ten JEP‑driven enhancements, additional low‑level improvements, expanded security measures, updated Unicode support, JVM performance tweaks, and the introduction of the Oracle Java Verified Portfolio that now covers JavaFX, Helidon and VS Code extensions.
The article examines the sharp decline in MySQL’s commit activity since its 2006‑2007 peak, compares recent DB‑Engines rankings that show PostgreSQL overtaking MySQL, and attributes the downturn to Oracle’s management practices, technical setbacks, reduced open‑source community engagement, and a shift toward proprietary alternatives.
ByPassTamperPlus is a Python‑based collection of SQLMap tamper scripts tailored for MSSQL, MySQL and Oracle across multiple versions, employing version‑specific syntax, functions and obfuscation techniques to improve payload survivability against modern Web Application Firewalls, while acknowledging inherent limitations.
This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.
Even in 2026, installing databases like Oracle remains a complex, error‑prone process, and this article explores the historical roots, recent AI‑assisted attempts, and four key reasons why database installation still challenges engineers.
The article explains Oracle's Automatic Workload Repository (AWR) as a comprehensive performance‑diagnostic tool, breaks down its core functions, and then evaluates how several domestic databases such as Kingbase measure up in terms of report completeness, metric richness, SQL analysis, wait‑event handling, OS integration, and usability.
Oracle claims a new era for MySQL by moving commercial‑only features to the community edition and adding AI‑focused vector functions, but developers question whether these promises are timely or sufficient, fearing continued neglect of the open‑source community.
Amid growing concerns over Oracle's waning interest and recent layoffs in the MySQL core team, developers gathered in San Francisco to debate the database's future, weighing continued Oracle stewardship against creating open‑source forks such as hard‑forks like MariaDB or tracking forks like Percona's server.
This article walks through three common Oracle OCP exam questions—distinguishing permanent, temporary, and UNDO tablespaces, choosing the correct object versus system privilege syntax, and selecting the safest RMAN command for a hot backup—providing detailed explanations and the correct answers.
The MySQL Server repository on GitHub has seen no code commits for over three months, sparking concerns about Oracle's strategic shift, recent large‑scale layoffs, and the future sustainability of the community‑driven open‑source database.
This article examines the multi‑layered threats facing modern databases, outlines Oracle's comprehensive security capabilities—from firewalls and encryption to auditing and immutable tables—and compares them with the security features of leading domestic database products.
This article compares the execution‑plan generation, caching, and query‑performance characteristics of Oracle, MySQL, and PostgreSQL, explains how to view plans in each system, and provides practical tips for DBAs to interpret and optimize them effectively.
Oracles serve as the crucial bridge that enables smart contracts to access off‑chain data, and while they are the dominant solution for real‑time on‑chain updates, the article also explores alternative approaches such as centralized data entry, state channels, sidechains, and cross‑chain oracles, outlining their pros, cons, and challenges.
A client reported sudden Oracle database slowdown, prompting a post‑mortem analysis using AWR and TFA data that revealed GC bottlenecks, RAC heartbeat packet loss, and an intermittent storage link failure, ultimately resolved by disabling the faulty port and restarting the affected node.
Oracle's new AI Database 26ai replaces the earlier 23c version, adding generative and agent‑based AI capabilities, built‑in Agent Factory, MCP server integration, advanced security features, and forming the foundation for an Autonomous AI Lakehouse, while offering seamless upgrades for existing customers.
This article compares how Oracle, MySQL, and PostgreSQL generate, view, and interpret execution plans, highlighting differences in hint support, caching, query efficiency, and providing practical commands and visual examples to help DBAs diagnose and optimize database performance.
An in‑depth analysis reveals that Oracle’s AI‑focused cloud business, built on expensive Nvidia GPU rentals for OpenAI and other AI developers, generates massive revenue but suffers from alarmingly low profit margins, creating a systemic risk that could ripple through the entire AI infrastructure ecosystem.
Oracle announced that Safra Catz will share the CEO role with Clay Magouyrk and Mike Sicilia, a move aimed at strengthening its cloud infrastructure and AI capabilities, while highlighting record financial performance and outlining the strategic importance of OCI, AI-driven growth, and the company's involvement in rebuilding TikTok's algorithm for U.S. security.
Oracle’s massive September 2025 layoffs hit the MySQL core team, prompting concerns about reduced innovation, a shift toward its Heatwave analytics product, and the broader impact on open‑source database ecosystems and developer choices.
This article analyzes a real‑world OceanBase‑to‑Oracle incremental sync failure caused by VARCHAR2 length limits, explains the role of NLS_LENGTH_SEMANTICS and MAX_STRING_SIZE, and provides three practical solutions—including extending string size, using CLOB fields, and PL/SQL workarounds—to reliably insert data exceeding 4000 bytes.
Yesterday Oracle’s shares surged after the company announced a massive $300 billion, five‑year AI compute procurement agreement with OpenAI, set to begin in 2027, highlighting the tech giant’s high‑risk bet on AI infrastructure, massive data‑center investments, and the financial pressures both firms face in the race to dominate artificial intelligence.
Recent Dimensional Research data shows that 73% of surveyed enterprises have encountered Oracle‑initiated Java license audits, prompting 15% to complete migration, 22% to start, and 25% to plan moving to OpenJDK or other open‑source JDKs, driven by cost and compliance pressures.
Oracle's recent large‑scale layoffs in its MySQL division have sparked community worries about the future of the world’s most popular open‑source database, highlighting shifts toward AI‑focused services and the rise of MariaDB as an alternative.
This guide walks you through preparing Oracle and PostgreSQL test tables, inserting sample data, converting an Oracle stored procedure to PostgreSQL using the SQLShift tool, and fixing the few manual adjustments needed for a successful migration.
The article explains why mastering database backup and recovery—including failure types, logical vs. physical backups, flashback, full and partial restores, a weekly backup strategy, RMAN configuration, shell scripts, and monitoring queries—is essential for avoiding costly mistakes and passing a new‑job probation.
A recent global survey of 500 IT asset managers reveals that 73% of enterprises faced Oracle Java compliance audits, with many spending over $500,000 annually on licensing issues, prompting a massive shift toward open‑source Java alternatives like OpenJDK.
This article walks through four real‑world SQL performance disasters—chaotic joins, NULL‑value scans, LOB full‑table scans, and massive batch deletions—explaining why they cripple databases and providing concrete, step‑by‑step rewrite and indexing solutions to restore stability and speed.
This article explains why optimistic locking can fail under high concurrency, demonstrates how to apply database‑level pessimistic locks with Spring Data JPA, configure lock timeouts for MySQL and Oracle, and gracefully handle lock exceptions using Spring Retry.
Alibaba Cloud reported a 2024 revenue of 1134.99 billion RMB, becoming the first profitable Chinese cloud provider, while Oracle secured a $30 billion contract—double Alibaba's earnings—highlighting a stark China‑US gap in the enterprise cloud services market.
This article explains Oracle's step‑by‑step processing of a SQL statement—including the client submission, parsing checks, optimizer decision‑making, row‑source generation, and final execution—while illustrating hard and soft parses, optimizer components, and practical query‑plan queries.
When an Oracle table is accidentally truncated, this guide explains what TRUNCATE does, why recovery is difficult, and walks through four practical tools—Fy_Recover_Data, ODU, BBED, and GDUL—detailing step‑by‑step commands to restore the lost data safely.
A detailed Oracle 10g case study reveals how excessive log file sync waits, caused by I/O performance problems and frequent log switches on aging mechanical storage, lead to database hangs, and provides step‑by‑step analysis and practical mitigation tips.
This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.
This article demonstrates three SQL techniques—DISTINCT, GROUP BY, and the ROW_NUMBER window function—for deduplicating records and counting unique tasks, comparing their syntax, performance, and behavior across MySQL, Hive, and Oracle environments.
Oracle disclosed that attackers stole data from its legacy Cloud Classic servers, posted the breach on security forums, and claimed millions of records were compromised, while the company insists its Oracle Cloud Infrastructure was never breached, prompting widespread criticism and concern.
This article presents a hands‑on evaluation of several large language models—including Mistral‑Small, Deepseek‑r1, Llama 3.3 and ChatGPT‑4‑go—on Oracle database bad‑block errors, RAG‑based document retrieval, and log‑driven reasoning, revealing performance gaps, scoring results, and practical DBA implications.
Oracle’s recent cloud security breach, allegedly exposing six million records from dozens of customers worldwide, has sparked FBI investigations, a class‑action lawsuit, and revelations about outdated middleware and evidence‑tampering, highlighting critical risks in cloud infrastructure and the need for stronger data protection.
The article explains Oracle's ongoing legal battle over the JavaScript trademark, Deno's push for its cancellation, the upcoming TTAB decision, and the broader implications for the JavaScript community and trademark law.
During a New Year holiday, an Oracle database suffered severe hangs due to a GC buffer busy acquire wait event caused by a faulty heartbeat network cable, leading to index unusable errors and extensive troubleshooting steps that reveal common causes and preventive measures.
This article compares Oracle, PostgreSQL, and MySQL across core features, typical use cases, transaction support, storage engines, licensing, provides simplified installation steps, demonstrates basic SQL operations such as creating tables, inserting and querying data, and highlights key differences like auto‑increment handling and string‑matching functions.
The article describes a real‑world Oracle ORA‑000060 deadlock encountered during bulk updates of user records, explains the root cause of unsorted duplicate user_id entries across parallel threads, and outlines practical solutions such as sorting input files and adjusting transaction order, illustrated with MyBatis code and DeepSeek insights.
The article describes a production deadlock (ORA-000060) caused by unsorted, duplicate user_id rows in a file processed in parallel batch updates, shows MyBatis XML code, illustrates conflicting thread execution, and provides practical solutions such as sorting the input and deduplicating records.
The article recounts decades‑long Oracle DBA experiences, describing early‑era crashes, notorious ORA‑1591 and ORA‑600 errors, troubleshooting tactics, and how those hardships forged highly skilled DBAs while highlighting the evolution toward more mature database systems.
The article examines the legal clash between Deno and Oracle over the JavaScript trademark, tracing its history from Netscape's creation to today's lawsuit, and explores the potential outcomes and their impact on the developer community and the future of web programming.
The article explains how Oracle DBAs transitioning to PostgreSQL often misinterpret work_mem and cursor sharing, showing how improper settings can drastically change execution plans, increase query time, and cause performance issues, while also highlighting differences in memory management and plan caching between the two systems.
This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.
This article examines the compatibility landscape of major Chinese database products, comparing their support for Oracle, MySQL, PostgreSQL and other standards, and outlines the available assessment and migration tools to help users choose the right solution for heterogeneous environments.
Chinese databasesDatabase CompatibilityMigration Tools
This article surveys the compatibility of major Chinese database products with Oracle, MySQL, PostgreSQL and other systems, covering compatibility targets, levels, assessment methods, migration tools, and specific feature support such as protocols, data types, character sets, SQL syntax, procedural languages, built‑in functions, system views, optimizer capabilities and security features.
Chinese databasesDatabase CompatibilityEvaluation Tools
This article shares a ready‑to‑run Oracle SQL*Plus script that lists active sessions with details such as instance ID, username, execution time, SQL text snippet, current event, and wait seconds, plus an example output for immediate performance troubleshooting.
This article provides a detailed list of 51 video tutorials covering Oracle database download, installation, basic SQL operations, DML/DQL commands, PL/SQL programming, advanced features, and related database administration topics, offering a complete learning path for Oracle practitioners.
The article recounts a personal experience of a failed train ticket change, analyzes segment‑wise seat availability, proposes a database model, and demonstrates a SQL query that allocates seats per segment, showing how such logic could enable full‑journey booking and even inspired a new feature on the 12306 platform.
The JavaScript community, backed by over 2,500 developers and key language creators, is urging Oracle to abandon its unused JavaScript trademark to free the language from legal constraints and restore open use for projects, conferences, and education.
Oracle’s 2024 global user survey uncovers preferred databases, key factors for database selection, the advantages of Oracle Cloud Infrastructure, and emerging AI use cases, providing a comprehensive view of current enterprise priorities and future expectations in data management and cloud services.
The article examines Oracle’s comprehensive SQL management capabilities—such as parsing, plan caching, process tracing, execution plan handling, optimization, and runtime monitoring—and compares them with the features offered by major Chinese and open‑source databases, highlighting gaps, strengths, and practical recommendations for adopting domestic solutions.
The article analyzes a production out‑of‑memory crash triggered by a pagination bug that misused the OFFSET parameter, explains why the error escaped testing and code review, and presents corrected pagination techniques for Oracle, MySQL and MyBatis to prevent similar failures.
This article recounts L's attempt to change a train ticket, analyzes seat availability across four segments, and presents a minimal SQL model with table creation, data insertion, and a query that determines feasible seat combinations, demonstrating how segment‑wise seat allocation can enable complete journey booking.
This article examines the advantages and disadvantages of using stored procedures in relational databases, discusses common pitfalls and vendor‑specific issues, provides guidance for Oracle stored procedures, and offers practical recommendations on when and how to apply them effectively.
This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.
A 2023 survey of 663 Java professionals reveals a sharp decline in Oracle Java's market share, with 86% planning or already migrating to OpenJDK alternatives due to cost, licensing uncertainty, audit risk, and a preference for open‑source solutions, while highlighting migration timelines, satisfaction, and emerging pricing models.
A recent Azul survey of 663 Java professionals shows that 86% of Oracle Java users are migrating to OpenJDK due to high costs, licensing uncertainty, audit risks, and a preference for open‑source alternatives, with most migrations completing within a year and delivering significant cost savings.
During the early 2000s, the database industry faced Y2K-driven robustness upgrades, intensified global rivalry among Oracle, IBM, Sybase and Informix, while Chinese university‑originated systems like Kingbase and DaMeng leveraged government backing and venture capital to begin challenging foreign dominance.
The article examines Oracle's release of MySQL 9.0, highlighting developer disappointment, serious bugs warned by Percona, the company's shift toward the proprietary HeatWave analytics engine, and the broader implications for the open‑source MySQL community.
A single runaway SQL caused a 12‑hour outage of a core Oracle system; the article walks through the fault symptoms, AWR and ASH analysis, abnormal SQL identification, execution‑plan changes caused by partition operations, and the step‑by‑step remediation that restored performance.
Oracle is aggressively pursuing organizations that use Java, even those not directly licensed, by tracking downloads and demanding retroactive fees or costly subscription plans, prompting many firms to uninstall Java and worry about the broader impact on the Java ecosystem.
This article walks through real‑world Oracle RAC failures caused by misconfigured VIP failover and SCAN IP load‑balancing, explains how to diagnose the symptoms, provides correct TAF and listener settings, and highlights essential configuration tips to ensure reliable high‑availability operation.
Oracle has begun sending Java license audit letters to Fortune 200 firms, shifting from its previous focus on small companies, while its new per‑employee pricing model and aggressive compliance checks spark criticism and push many developers toward alternative OpenJDK distributions.
The article examines Peter Zaitsev’s critique of Oracle’s stewardship of MySQL, debunks long‑standing myths, evaluates recent MySQL Heatwave features and performance gaps, and compares MySQL’s trajectory with PostgreSQL and other open‑source databases.
Oracle’s post‑acquisition strategy has left MySQL lagging behind modern developers, while PostgreSQL, praised for features like parallel queries and vector search, now dominates the open‑source database market, prompting calls for MySQL’s transfer to the Linux Foundation to avoid obsolescence.
This article walks through a real‑world Oracle index failure, explains why indexes become UNUSABLE, shows how to clean residual metadata, rebuild the index safely, outlines common causes for both regular and partitioned tables, and provides SQL scripts for monitoring invalid indexes.
Learn how to create a Go-based command-line tool that accepts user-supplied parameters to connect to an Oracle database using the loginWithServiceName function, execute arbitrary SQL queries, and display results, complete with full source code, flag parsing, and error handling.