SUMMARY: Learn how to configure Oracle Database to start and stop automatically during Linux system reboots using the oratab file and OS startup configuration. Table of contentsSUMMARY:IntroductionUpdate /etc/oratabfile for Oracle Autostart (All Systems)Section 1:...
Oracle Blog Posts
Oracle AI Database 26ai: Now Available for Linux x86-64 On-Premises
SUMMARY: Oracle has officially released Oracle AI Database 26ai for Linux x86-64, enabling enterprise organizations to deploy advanced AI capabilities and vector search directly within their secure on-premises data centers. Oracle consolidated the previous 23ai family...
Top 10 Reasons for Oracle VKTM Time Drift: Insights from a Senior Oracle DBA
SUMMARY: This blog outlines the top 10 causes of Oracle VKTM time drift (OS/VM issues and bugs) and offers practical solutions. Table of contentsSUMMARY:IntroductionUnderstanding VKTMCriticality of VKTM in RAC EnvironmentsCore Causes of VKTM Time Drift1. Aggressive...
Performance Tuning in Oracle 19c: From AWR to SQL Plan Management
SUMMARY: Database Administrators can maximize the stability and efficiency of Oracle 19c environments by leveraging built-in diagnostic tools to pinpoint bottlenecks, automate query optimization, and enforce consistent execution plans. The Automatic Workload...
Oracle 12c to 19c Database Upgrade Manual
SUMMARY: Database administrators can achieve improved performance, stability, and extended support by executing a four-step migration from Oracle 12c to the long-term support version 19c, primarily utilizing the visual and automated Database Upgrade Assistant (DBUA)....
RMAN Level 0 and Level 1 Backup Strategy in Oracle 19c
Summary This blog post outlines how to design and implement an RMAN Level 0 and Level 1 incremental backup plan in Oracle 19c, covering configuration, automation, validation, and maintenance for reliable database recovery. Table of contentsSummaryIntroductionKey...
Modernizing Education: How Sweetwater Union High School District Partnered with Virtual-DBA for Database Success
SUMMARY: XTIVIA's Virtual-DBA service enabled the Sweetwater Union High School District to overcome the challenges of an outdated database by successfully migrating its legacy Oracle system to SQL Server. The district decommissioned its expensive legacy Oracle system,...
Using Analyzer for EBS Performance and Statistics
This blog will walk you through how to prepare your EBS environment, run the analyzer, and provide an overview of the results. We’ll also share XTIVIA’s hands-on experience running this analyzer in a test EBS instance.
Optimize Your OCI Spend: Expert Strategies for Cost-Effective Oracle Cloud
SUMMARY: Optimizing Oracle Cloud Infrastructure (OCI) is crucial for maximizing ROI, and XTIVIA's Oracle-certified experts help businesses achieve this by right-sizing compute, storage, and networking resources to stop overspending. Analyze and right-size compute...