What Does China’s 2016 Oracle Database Landscape Reveal?

1. Industry Characteristics

Bethune, a cloud‑based Oracle database diagnostic platform, collected health‑check data from 1,841 Oracle instances belonging to 485 users across 18 industries in 2016. The analysis shows that financial, telecommunications, IT and energy sectors prioritize database health the most, reflecting more mature operation and maintenance practices.

2. System Configuration

Database Version

Oracle 11gR2 remains the dominant version, while adoption of 12.1 has been rising since 2015 but still accounts for less than 15% of installations. Versions older than 11g are rarely used, indicating a strong preference for the stable Release 2 series. Many installations still run outdated minor versions without applying recent CPU and PSU patches, and over half have never received any patch.

Operating System

Linux and AIX are now the primary operating systems for Oracle deployments. Linux has become the leading platform, especially in financial, telecommunications and other sectors, while AIX remains prevalent in finance and telecom due to its high‑availability features.

Host Configuration

CPU and memory allocations vary by industry. Electronics manufacturing averages 84 CPU cores per database, reflecting high concurrency needs, whereas the energy sector averages 270 GB of memory per database to support intensive I/O workloads. Communication and financial sectors show more balanced resource provisioning.

Storage Configuration

Since Oracle 11.2, Automatic Storage Management (ASM) has largely replaced raw devices. Raw devices are now mainly seen on AIX + 10g systems, while Windows deployments continue to use traditional file systems.

3. Data Scale

Database size indicates system pressure and architectural planning quality. Broadcast media, telecommunications and transportation have the largest individual databases, with the telecommunications sector reaching a single‑instance size of 228 TB. The financial sector averages 628 GB per database.

4. High Availability

Most customers enable archive logging, providing a foundation for data recovery. Oracle Real Application Clusters (RAC) is used by 51% of surveyed instances, while Data Guard adoption remains low, suggesting limited awareness or investment in advanced disaster‑recovery solutions.

5. Failures

Top‑10 failure types are dominated by space‑related and network‑connection issues, which are relatively simple to resolve but occur frequently, even in well‑managed telecom environments, indicating a need for stronger monitoring and preventive measures.

The full report also covers security, database design, SQL tuning, hidden parameters, performance metrics, and abnormal shutdown analysis. The complete document can be downloaded from the Bethune platform.

Bethune’s intelligent diagnostics help engineers quickly identify and mitigate potential risks, improving operational efficiency during peak periods such as the Spring Festival holiday.

For any issues, users can submit feedback via the official website or contact the WeChat assistant (sunx5126) to join the user community.

Bethune has received the 2016 Database Operations Gold Award from DOIT for its ease of use, comprehensive analysis, and proactive risk detection.

Disclaimer: Data originates from the Bethune database intelligent diagnostic platform; please cite the source when referencing. Bethune only collects configuration, performance and log data, not business data, and currently supports Oracle versions 10.1 and above.