BestHub
Sign in
Tag

Oracle

1 views collected around this technical thread.

Wukong Talks Architecture
Wukong Talks Architecture
Apr 28, 2025 · Databases

Comprehensive Guide to Popular Database Management Tools

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.

DBeaverDatabase ToolsMySQL
0 likes · 19 min read
Comprehensive Guide to Popular Database Management Tools
IT Xianyu
IT Xianyu
Mar 24, 2025 · Databases

Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations

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.

Database ComparisonInstallationMySQL
0 likes · 7 min read
Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations
IT Services Circle
IT Services Circle
Feb 13, 2025 · Databases

Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis

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.

Batch UpdateDatabaseMyBatis
0 likes · 4 min read
Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis
Practical DevOps Architecture
Practical DevOps Architecture
Sep 29, 2024 · Databases

Comprehensive Oracle Database Tutorial Series (Download, Installation, SQL Basics, PL/SQL, and Advanced Topics)

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.

AdvancedDatabaseInstallation
0 likes · 6 min read
Comprehensive Oracle Database Tutorial Series (Download, Installation, SQL Basics, PL/SQL, and Advanced Topics)
IT Services Circle
IT Services Circle
Aug 31, 2024 · Databases

Production OOM Incident Caused by Incorrect Pagination and How to Fix It

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.

MyBatisMySQLOracle
0 likes · 6 min read
Production OOM Incident Caused by Incorrect Pagination and How to Fix It
IT Services Circle
IT Services Circle
Aug 6, 2024 · Backend Development

Oracle Java Market Share Decline and Migration Trends: 2023 Survey Insights

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.

JDK Market ShareJavaMigration
0 likes · 7 min read
Oracle Java Market Share Decline and Migration Trends: 2023 Survey Insights
Tencent Cloud Developer
Tencent Cloud Developer
Jul 26, 2024 · Databases

Database Landscape in the 2000s: Global Competition and the Rise of Chinese Vendors

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.

2000sChinese databasesDatabase History
0 likes · 13 min read
Database Landscape in the 2000s: Global Competition and the Rise of Chinese Vendors
Architecture Digest
Architecture Digest
Jun 14, 2024 · Information Security

Oracle Expands Java License Audits to Fortune 200 Companies and What It Means for Developers

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.

JavaOpenJDKOracle
0 likes · 9 min read
Oracle Expands Java License Audits to Fortune 200 Companies and What It Means for Developers
Java Tech Enthusiast
Java Tech Enthusiast
Jun 13, 2024 · Databases

MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL

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.

DB-EnginesDatabaseHeatWave
0 likes · 7 min read
MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries

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.

Anti JoinOceanBaseOptimization
0 likes · 17 min read
Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2024 · Databases

Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance

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.

Global IndexLocal IndexOceanBase
0 likes · 32 min read
Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance
Top Architect
Top Architect
Nov 24, 2023 · Databases

Introducing MySQL Innovation and Long‑Term Support (LTS) Versions

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.

Database VersioningHeatWaveMySQL
0 likes · 17 min read
Introducing MySQL Innovation and Long‑Term Support (LTS) Versions
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2023 · Databases

Understanding Duplicate Indexes on the Same Column in MySQL and Oracle

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.

MySQLOracleSQL
0 likes · 7 min read
Understanding Duplicate Indexes on the Same Column in MySQL and Oracle
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2023 · Databases

Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase

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.

Database ViewsOceanBaseOracle
0 likes · 19 min read
Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 11, 2023 · Databases

Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle

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.

DataXDatabaseMigration
0 likes · 16 min read
Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 7, 2023 · Backend Development

How to Configure Master‑Slave Data Sources in Spring Boot with JPA & MyBatis

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.

HikariCPJPAMyBatis
0 likes · 21 min read
How to Configure Master‑Slave Data Sources in Spring Boot with JPA & MyBatis
Architecture Digest
Architecture Digest
Jul 11, 2023 · Operations

Oracle's Controversial Java SE Subscription Policy and Its Impact on Enterprises

Oracle's recent shift to a subscription-based Java SE licensing model, featuring employee‑count pricing tiers and aggressive email outreach, has sparked widespread concern among enterprises, prompting costly compliance challenges, discussions of alternative OpenJDK adoption, and calls for careful negotiation with Oracle.

JavaOpenJDKOracle
0 likes · 8 min read
Oracle's Controversial Java SE Subscription Policy and Its Impact on Enterprises
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 26, 2023 · Databases

Detecting Invalid Date Data in Oracle and MySQL Using Error Logs and Temporary Tables

This article explains how to proactively identify non‑conforming date values during Oracle or MySQL data migrations by creating test tables, leveraging DBMS_ERRLOG for Oracle, using strict SQL_MODE and temporary tables for MySQL, and optionally applying regular‑expression checks.

MySQLOracleSQL
0 likes · 7 min read
Detecting Invalid Date Data in Oracle and MySQL Using Error Logs and Temporary Tables