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’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.
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.
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.
This article compiles over a decade of real‑world Oracle single‑instance and RAC deployment experiences, detailing compatibility issues, specific bugs encountered in versions 10g, 11g, 12c, 19c on Linux platforms, and step‑by‑step remediation commands, scripts, and configuration adjustments to ensure successful installation.
Oracle announced its upcoming AI coding assistant, Code Assist, tailored for Java, Oracle Database, NetSuite scripts, and Oracle Cloud, offering chat-driven code suggestions, documentation generation, and security scanning across VS Code and JetBrains IDEs, while emphasizing multi‑language support and data privacy.
Oracle’s latest release, Database 23ai, upgrades its 23c platform with AI-driven vector search, RAG capabilities, and enhanced JSON and graph querying, positioning the database as a unified, secure, and scalable solution for handling structured, semi‑structured, and unstructured data across cloud and on‑premises environments.
This guide explains how to rescue both physically and logically deleted Oracle databases, covering RMAN file recovery, full database restoration, flashback table techniques, recycle‑bin usage, flashback database configuration, and essential backup strategies to prevent data loss.
This article analyzes a slow NOT IN subquery that OceanBase rewrites into a NESTED‑LOOP ANTI JOIN, explains why HASH ANTI JOIN is not chosen due to NULL‑sensitive semantics and missing NOT NULL constraints, compares the behavior with Oracle's Null‑Aware Anti Join, and provides practical rewrite and hint‑based optimization recommendations.
Oracle warns Java developers that upgrading Apple Silicon macOS Sonoma to version 14.4 can crash JetBrains IDEs by sending a SIGKILL signal, and advises postponing the update until a fix is available, highlighting the impact on multiple JDK versions.
The article examines how shifting industry trends, cloud adoption, and the rise of domestic databases force Oracle DBAs to choose between staying the course, expanding their skill set, or pivoting entirely, offering practical guidance for each path.
The article examines Oracle’s evolution from RAC‑based sharding to the 23c Global Distributed Database, highlighting its RAFT replication, cross‑region capabilities, compliance benefits, and performance advantages that position it as a true multi‑cloud, multi‑location solution for modern OLTP workloads.
This article explains the differences between global and local indexes in OceanBase, analyzes why queries using global unique indexes run significantly faster than those using local indexes during Oracle migration, and provides detailed SQL examples, execution plans, and performance testing results to guide database optimization.
This comprehensive tutorial walks you through configuring Oracle Data Guard for master‑slave replication, covering prerequisites, detailed command‑by‑command steps, common pitfalls, testing procedures, switchover operations, and post‑switch recovery, all illustrated with diagrams and code snippets.
This article explains how to locate, trace, and resolve a syntax error that occurs when a stored procedure migrated from Oracle to OceanBase fails, detailing the use of trace IDs, SQL reconstruction, cursor analysis, and the necessary adjustments to primary‑key handling.
This guide provides complete shell scripts and step‑by‑step instructions for performing remote backups and restores of MySQL, Oracle, and PostgreSQL databases on Linux, including directory creation, compression, secure copy, cron scheduling, and cleanup of old backup files.
A veteran Oracle DBA recounts the painful history of early Oracle versions, explains classic errors like ORA-1591 and ORA-1578, shares troubleshooting tactics, and reflects on how those hardships forged the expertise needed to master today’s complex database environments.
The article explains MySQL’s new versioning model, introducing Innovation and Long‑Term Support (LTS) releases, detailing transition timelines, feature deprecation, upgrade and downgrade strategies, and the role of MySQL HeatWave, while also providing links to download and community resources.
This article examines why MySQL permits creating multiple identical indexes on the same column, demonstrates the behavior through several tests, compares it with Oracle's stricter restrictions, and explains how the optimizer selects indexes, highlighting practical implications for database design.
The 2023 State of Java report, based on a survey of over 2,000 Java professionals, reveals that Java adoption stays strong with most companies using LTS versions, migrating to the cloud, confronting rising costs and security challenges, while Oracle's market share declines in favor of OpenJDK alternatives.
This guide details essential Oracle database daily inspection commands—covering instance status, tablespace health, resource usage, performance metrics, server CPU/memory/I/O checks, and security audits—to help DBAs ensure system stability and quickly diagnose issues.
This article investigates why Oracle and OceanBase return different results when querying the USER_TAB_COLUMNS view in stored procedures, demonstrates reproducible tests, analyzes system view behavior, and proposes workarounds such as using ALL_TAB_COLUMNS, creating synonyms, intermediate tables, or materialized views to ensure consistent table name retrieval.
This article demonstrates two practical approaches for handling MySQL auto‑increment columns during migration to OB Oracle—creating custom sequences with DBCAT and using the GENERATED BY DEFAULT AS IDENTITY attribute—provides step‑by‑step commands, scripts, and validation results to help DBA engineers achieve seamless primary‑key migration.
Oracle 23c turns the converged database vision into reality by unifying relational, document, and graph data under a single SQL engine, offering built‑in microservice support, lock‑free reservations, immutable tables, and an integrated SQL firewall to reduce architecture complexity and development cost.
This guide walks through setting up a Spring Boot 2.4.12 project with JDK 1.8, Oracle, and two data sources—master and slave—covering Maven dependencies, application.yml settings, custom property classes, HikariDataSource beans, JPA EntityManagerFactory, MyBatis SqlSessionFactory, mapper scanning, and testing entity creation to verify successful configuration.
This article explains how to improve Oracle database performance by creating archive tables and triggers, and demonstrates step‑by‑step PHP code for connecting to Oracle, moving old records, and querying archived data.
Oracle’s aggressive shift to a per‑employee Java SE subscription has sparked widespread concern among enterprises, as the new pricing tiers and licensing audits threaten to dramatically increase costs and force companies to reconsider their Java deployment strategies.
