In an earlier article we discussed two very popular reasons, LOAD_OPTIMIZER_STATS and HASH_MATCH_FAILEDpushing Oracle to refuse sharing an existing execution plan and, thereby, hard parsing a new plan...
SQL Navigator has been and continues to be the go-to product for Oracle Developers. With the coming release of SQL Navigator 7.3 we’ll be adding some new features and improving existing features alon...
Pair Programming Pair programming was another fantastic but contentious idea that emerged from the agile movement of the 1990s. Pair programming is when two developers physically sit and work together...
Let's talk about replication-friendly GDS. We have seen series of Global data services, now this article is purely for Data Guard friendly global data services or we can say replication friendly servi...
Quick overview of how to install GitHub and then interact with it directly through the SQL Navigator tool via the Team Coding feature. So let’s get started! Following is a list of all of the tools ...
We have seen managing Global data services in Data Guard configuring by failover test and so on, if any situation occur like the role transitions of the Data Guard configuration between Primary databa...
Spotlight on SQL Server Enterprise 11.6 is here! So what’s new? Spotlight introduces Federation architecture A Spotlight Client can now monitor connections from multiple Spotlight Diagnostic Servers i...
Test Driven Design The adoption of agile development is clearly on the rise and with it comes–at least the consideration for–Test Driven Design (TDD). Although the decision to embrace TDD in your deve...
We are pleased to announce the release of Toad for SAP Solutions v3.1. Toad for SAP Solutions is a comprehensive solution to improve DBA and development effectiveness and productivity across all of SA...
We are pleased to announce the release of Toad for DB2 v6.2. This new version is now available for customers to download at our Toad for DB2 product page. Toad for DB2 is a comprehensive solution to ...
For most people troubleshooting SQL query performance problems is a necessity rather than a preference. Very often they are using a trial and error strategy to overcome those frustrating situations. U...
Expert Advice Whose advice are you listening to when building your requirements? Sure, your end users think they know what they want, but are they the right people to assist you in designing a solutio...
