Blog

Start Here

Get in touch with a
TriCore Solutions specialist

Blog

Ravi Bhatia

Find me on:

Recent Posts

Blog | Dec 16, 2016

VLDB Performance Tuning Tale

Posted by Ravi Bhatia

Tuning very large databases, more commonly known as VLDB, has always been a challenging part of DBAs jobs. Delivering optimal performance for applications that access a VLDB is essential for the business. In this blog I will review common problems that impact VLDBs performance and will also cover a real world scenario demonstrating the challenge and our team’s solution.
Read More

Blog | Feb 23, 2016

How to Migrate Oracle Database from Solaris to Linux

Posted by Ravi Bhatia

Proprietary UNIX servers depreciate rapidly and they are often little of their original value after just a few years of usage due to their costs which varied from hundreds of thousands of dollars. Another reason is the increasing power of so-called commodity chips from Intel Corp & low-cost operating systems like Linux. 
Read More

Blog | Dec 3, 2015

Special Case of Bi-Directional Replication Part 4

Posted by Ravi Bhatia


In this part we walk through the steps to upgrade 11.2.0.3 single instance database having bi-directional streams setup to RAC machine having ODA setup.

Read More

Blog | Dec 2, 2015

Special Case of Bi-Directional Replication Part 3

Posted by Ravi Bhatia


This is the third installment of the blog series. In this part we will walk through the upgrade of 11.1.0.7 single instance database having bi-directional streams setup to 11.2.0.3 single instance database.

Read More

Blog | Nov 19, 2015

Special Case of Bi-Directional Replication Setup Part 2

Posted by Ravi Bhatia


In this part we will complete complete the Restoration & BI-Directional Streams Setup on the crashed Node.
Read More

Blog | Nov 18, 2015

Special Case of Bi-Directional Replication Part 1

Posted by Ravi Bhatia


The database in this case was restored, recovered, upgraded & migrated to an ODA (Oracle Database Appliance) server as a part of bi-directional replication streams setup.

Read More

Blog | May 20, 2015

How to Capture Deadlocks in MySQL Instance

Posted by Ravi Bhatia

The deadlocks can be rightly called the “show stoppers” for the production environments where the application transactions can get errors without any details being logged in the database systems. For instance, in the lower versions of MySQL (below 5.6), capturing the deadlock information is not available with the MySQL provided log files. This blog will help users/MySQL DBAs to capture such information by making use of a simple shell script and thus providing the important details regarding the deadlock errors.

Read More

Blog | Jun 18, 2014

Considerations For The Switchovers of Oracle Databases using Data Guard (DG) Broker

Posted by Ravi Bhatia

In this blog we’ll discuss all of the considerations as well as detail the steps to perform the planned switchover between an Oracle 11g R2 Primary & the standby databases.

Read More

Blog | May 22, 2014

Fix Unstable Plans by implementing Baselines

Posted by Ravi Bhatia


The issue we’ll discuss is related to one of the SQL Queries in a time sensitive ETL process taking hours to complete as compared to previous days with runtimes measured in minutes.

Read More