This video shows how to build accurate schema deployment scripts with Toad for Oracle Xpert Edition....
This video shows how to auto-optimize SQL code with Toad for Oracle Xpert Edition....
This video shows how to enable code quality assurance with Toad for Oracle Xpert Edition....
This video shows how to generate realistic datasets with Toad for Oracle Xpert Edition....
This video shows how to analyze code with Toad for Oracle Xpert Edition....
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...
Using indexes can improve the performance of applications using the database. This is a pretty well known fact. However, determining which index, or combination of indexes that will give you the best ...
Toad offers cool feature called make/strip code. It allows you to copy code from, say, C# or Java into Toad, turn it into simple SQL, optimize it, then send it back to the original format for inclusio...
Yes. In Editor, right-click and choose Refactor: convert to/from ANSI join. The query builder also offers this functionality. For example, you can send Editor contents to the query builder to "see" yo...
