Iterative and Incremental Delopment Are you challenged with getting your stakeholders to agree on one requirement? If so, don't feel alone. It's not uncommon as a business analyst to be stuck in the i...
Oracle Text (formerly known as InterMedia Text and ConText) is a full text indexing functionality. With Oracle text indexes (also known as Domain index), we can index text documents and search it base...
Since in Oracle Database 12c we can now use Active Duplicate using Backup set we also have another option, create that backupset Compressed, in that case what we are doing is to compress the BackupSet...
In previous versions, the only way to use Active Duplicate was with "image copies". However Oracle 12c introduced a new feature for Active Duplicate operations, now it is possible to do the duplicatio...
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...
