Tag: sql

How to determine RMAN backup size

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation for the SQL query. Why is this important? Because, as part of a backup review, it’s good to know the growth for the backup…

Read More >

Oracle Live SQL revised

If you’re not familiar with the Oracle Live SQL environment, then you should definitely try it. I wrote a blog some time ago on what it is and how to work with execution plans there. Here I will provide an…

Read More >

Oracle SQL Developer – Now in Web!

For some time, I was trying to use a Google Pixelbook for my work. It was kind of a challenge and among other things, I struggled to work without a good web-based SQL client or tool. I used a jump…

Read More >

Tackling Time Troubles – how to use dates correctly in Oracle

For the Oracle Code series of events I have delivered an older but still relevant talk called “Tackling Time Troubles.” Half of it is nice-to-know geek trivia and the other half is a few points on how to avoid very…

Read More >

How to Display Database Statistics for All Objects Used in a SQL Statement

When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the statistics are up-to-date for all objects that are used in the execution plans. There are a number of…

Read More >

Log Buffer #517: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Log Buffer #512: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Reading Execution Plans for Parallel DML

Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show…

Read More >

Distinguish Real SQL Execution Plans from Fake Ones!

Oracle database consultant Mohammad Faisal demonstrates various SQL execution plan extraction methods.

Read More >

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 >
Page 1 of 212