Unplanned outages are very expensive, and the cost of downtime is rising as almost all mission critical systems are fully automated. Industries like banking …
Read More »MySQL Enterprise Backup
Pre-requites: Must have MySQL Enterprise Edition installed Download media file : meb-4.1.0-el6.x86_64.rpm (For Linux Platform) Installation of MySQL Enterprise Backup Command to install …
Read More »New Audit Mechanism on Oracle 12c : Unified Auditing
Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …
Read More »How To Log More Detailed Information in Oracle Listener Trace?
If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …
Read More »How Do We Get Over an Interruption With Minimal Damage?
A few weeks ago a client called around 11:00 pm and said that they received an error in a very critical Microsoft SQL Server …
Read More »SQL Server AlwaysOn Availability Groups step by step
I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …
Read More »Upgrade Oracle Opatch Version
OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …
Read More »How To Fetch Explain Plan
Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …
Read More »How to Unlock an Expired Oracle User Whose Password is Unknown
In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …
Read More »Why is so much data being written into DBQL?
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …
Read More »