Tag: sql

Resolving Update-Update Conflict in Peer-to-Peer Replication

Hemantgiri Goswami, Microsoft SQL Server MVP and Lead Database Consultant, discusses how to resolve an Update-Update Conflict in Peer-to-Peer Replication in SQL.

Read More >

The 2nd Annual PASS Summit Bloggers Meetup (2015)

I’m excited to announce the second annual PASS Summit Bloggers Meetup! We began this last year and it was cool but this year will be even cooler! What: PASS Summit Bloggers Meetup 2015 When: Thursday, October 29th, 5:30pm Where: Sports Restaurant…

Read More >

Oracle 12c – Adaptive Query Optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >

Pro-active AWR Data Mining to Find Change in SQL Execution Plan

Many times we have been called for the poor performance of a database and it has been narrowed down to a  SQL statement. Subsequent analysis have shown that the execution plan has been changed and a wrong execution plan was being…

Read More >

How to Tune Using v$mystat

When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. I had a situation that required to look at these stats so I could see why one query would run fast and sometimes much slower. I wrote a simple wrapper ksh shell script for the query. It saves the session statistics in a table before and after the execution of the query and then prints out the statistics in a pivot report. This turned out to be very handy to me and therefore I chose to share it with the world :)

Read More >

REGEXP_REPLACE: Auto-Translate SQL Literals to Bind Vars

In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.

Read More >