Hi, Oracle12 introduced a new database architecture for the Oracle database: multi-tenant or pluggable databases. The basic concept is a container database (CDB) that can contain one or more pluggabl...
Are you getting execution performance bottlenecks in your PL/SQL code and not sure what to do? This video shows how to detect and report on a performance bottleneck using profiling techniques. Downlo...
When creating the video Using worksheets in Toad Edge , I touched briefly on the intellisene feature and how it gives you feedback when writing your queries. I wanted to double back on this topic to g...
Data analysts commonly use IF THEN ELSE statements when attempting to create a calculated field in a BI query and then filtering results on that calculated field. However, this can be difficult to do...
If you are currently using Toad for MySQL and are interested in Toad Edge, check out this matrix that compares features....
Want to apply Toad's robust development features to your MySQL environments? Well now you can! We have released a our new Toad Edge product initially focused on the MySQL platform, Toad Edge is a next...
In first part of this article, we Learnt What is ‘Session Cursor Caching’? How to Enable Session Cursor Caching? Explored ‘Session Cursor Caching’ in detail by means of following practical scenar...
Hi, I have a lot of knowledge about how Oracle’s indexes work. I’ll start with how Oracle B-tree indexes work, as well as syntax and practical uses for each. Oracle B-Tree Index Structure The abo...
Hi, This article is more of the rest of the story from March’s Lucky Breaks. (Click here to see the first blog). I want to share my successes in using PL/SQL to solve a rather common performance iss...
In the previous parts of this article series, we had a first look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. Besides multiple third-pa...
We detailed the concept and workings of Consolidation Planning for the Cloud, using Oracle Enterprise Manager Cloud Control 13c, in the previous partsof this article series. This is Part X, the final ...
Getting Off to a Good Start When it comes to data, Continuous Integration is one of those things that looks good on paper but is very difficult to implement. As a result, most data professionals conve...
