DBA Hub

đŸ“‹Steps in this guide1/5

Oracle Database 19c New Features: What DBAs Need to Know?

Explore Oracle 19c's new features like Automatic Indexing, JSON support, Data Guard, enhancing performance and security for DBAs & enterprises.

oracle configurationintermediate
by OracleDba
17 views
1

1. Automatic Indexing

One of the most talked-about features in Oracle 19c is Automatic Indexing . This feature helps in automatically creating, optimizing, and dropping indexes based on workload patterns. For DBAs managing large databases with complex queries, this can significantly reduce time spent on manual indexing tasks while improving query performance. Example: A large MNC like TCS implemented Automatic Indexing in their production systems to handle a massive increase in query workloads during peak hours. The database automatically created and maintained indexes, resulting in a 25% reduction in query times and freeing up DBAs to focus on other critical tasks.
2

2. JSON Data Type Support

Oracle 19c introduces native JSON Data Type Support , allowing the database to store JSON data directly. This simplifies JSON handling and improves performance by reducing storage requirements and query processing times. Practical Scenario: In a global tech company like Infosys , where applications interact with data stored in JSON format, this new feature reduces the complexity of managing JSON data within Oracle databases. The DBAs at Infosys saw improved performance when accessing and querying JSON data, which significantly boosted application performance.
3

3. Hybrid Partitioned Tables

Hybrid Partitioned Tables is another feature that allows DBAs to store part of a table in the database and the rest in external locations such as file systems or cloud storage. This is particularly useful for archiving data that is rarely accessed but still needs to be maintained for compliance purposes. Real-World Use: HCL Technologies used Hybrid Partitioned Tables to archive old transaction data to an external cloud service while keeping the frequently accessed data within their Oracle Database. This reduced storage costs by 40% and improved performance for active data queries.
4

4. Data Guard Automatic Role Transition

Oracle 19c introduces enhancements to Data Guard , including automatic role transitions between primary and standby databases in case of failure. This reduces the downtime during failovers, making it easier for DBAs to maintain high availability. Example: When Wipro faced an unexpected failure in their primary database, Data Guard’s automatic role transition quickly switched the role to the standby database, ensuring minimal disruption to business-critical applications and reducing recovery time.
5

5. Quarantine for Problematic Queries

Oracle 19c allows DBAs to identify and quarantine problematic SQL queries that cause performance issues. This prevents the same query from affecting the system repeatedly, giving DBAs more control over resource management. Practical Impact: For a banking institution like HDFC Bank , the ability to quarantine resource-intensive queries helps prevent sudden system slowdowns, ensuring smoother operation of critical banking services during peak hours.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!