This article is focused on how to monitor and troubleshoot the Data Guard when managing with Broker. There are many ways to monitor Data Guard such as using Generic/Traditional views, Using Grid contr...
In this article series, we are discussing Oracle Real User Experience Insight. Part I was here. This is the second article in the series. We discussed the RUEI installation requirements and other mat...
In many organizations, the IT department and its administrators monitor the performance of the database servers, databases, web servers and application servers. They are happy when these are working n...
In my last blog titled “Varying Database Benchmark Results” I tried to explain why people can often get varied performance results when running a specific database benchmark multiple times. I attempte...
I’ve been asked on numerous occasions why do peoples’ database benchmark results often vary. In other words why one observed transaction per second (TPS) value today and sometimes 20% or more off tomo...
Introduction This article explains how to configure Business Intelligence publisher report with Cloud Control 12.1.0.4, why business intelligence report necessary when the information publisher report...
Here is part of a case study that I would like to share with our users: "This enterprise data system is part of what makes Haas a leading global provider of chemical supply chain management(CSCM) sol...
While I was playing with "Scrub repair" in 12c I found the following: "RMAN doesn't report a corrupt block in a diskgroup with NORMAL or HIGH Redundancy if there is at least one good mirror block in ...
This is the third article of my 12c Adaptive Sampling series. Previously, we saw in Part 1 how ADS works for a single table (also for a group by clause) and in Part 2 for joins. As you know join card...
This is the second article of my 12c Adaptive Sampling series. In part I, we saw how dynamic sampling estimates single table and group by cardinality. In this part we will focus on how Adaptive Dynami...
How to know if I will be able to use successfully my RMAN Backup? that's is a question performed for many DBA's, RMAN also provide functions to validate corrupted blocks in the database, but also it p...
In this article you will learn how Oracle 12c dynamic sampling works. Cases where it helps the optimizer do good estimations as well as cases where it doesn’t will be presented. Only single table sele...
