Technical Thoughts

Introduction Real-Time SQL Monitoring in 12c has been enhanced tremendously, as in earlier releases this feature was meant to monitor only at sql level but in 12c it has been improved to monitor multiple sql and pl/sql in batch called as Database Operations. One of the biggest enhancement in 12c...

Introduction Bloom filter was invented in 1970 by Burton H. Bloom, it is a light weight probalistic algorithm which provides probability of presence and due to its nature there is a possiblity of false prositive of a presence, but it can never run into false negative. This helps in finding...

Issue decription In data warehousing database one of the MERGE statement with dimension and staging table was taking long time and never gets completed even after 4 hours. Also this MERGE statement was causing the whole database performance down to its knees due to high CPU and other resource usage....

Introduction In typical data warehousing environment existance of huge partitioned tables is very common, gathering statistics on such tables is challenging tasks. For partitioned tables there are two types of statistics Global and Patition level statistics. Gathering global statistics is very expensive and resource consuming operation as its scans whole...

In previous article we went through basics of SPD (SQL Plan Directive). In this article we will go through each topic which are very important when we start using SPD in production databases. Table of Contents: Result Cache Dynamic Sampling related sql’s time threshold Dynamic sampling due to SPD will...