SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …
Read More »How To Query Transaction Count in Oracle
A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …
Read More »Example of Using Data Pump
In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-66427eae926f7356668956/] [crayon-66427eae926fd713076479/] or [crayon-66427eae926ff842822640/] or [crayon-66427eae92701483445762/] …
Read More »Handling Oracle Audit Vault Services
In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-66427eae929c1153398447/] [crayon-66427eae929c7598560534/] [crayon-66427eae929c9695604950/] [crayon-66427eae929cb580675154/] …
Read More »High Availability Part I
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 »