In this article series, we are discussing Oracle Real User Experience Insight. Part II was here. This is the third article in the series. We looked at the creation of dashboard templates. We can see t...
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...
I have heard a lot of people ask "Why my SQL performance is vary depending on where the SQL is executed ?", sometimes you may notice that the same SQL is performing good in one place, but not good in...
This video provides an overview of basic features and user interface in Spotlight on Oracle. You can download a free limited version of Spotlight on Oracle...
This video shows how to identify SQL statements in need of tuning with Spotlight on Oracle....
This video shows how to identify and resolve database locks in Spotlight on Oracle....
This is part 3 of the Transformation and Cleans videos. I would like to go over the duplicates rule and calculated column rule. Duplicates can be a very common but complex task as duplicates ca...
This is part 2 of the Transformation and Cleanse videos. In my first video I went over the basics of the window, how to access and process data. In this video I will go over most of the rules. The...
In Toad Data Point 3.7 we have rewritten the Transformation and Cleanse window. This new window now includes data profiling information, many more transformation rules and a robust engine for processi...
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...
