Hi, I’ll start this series of blogs on New Features for Developers. The first is quick but good! A while back, December of 2014 to be exact, I blogged about APPROX_COUNT and how much faster it was. T...
In the previous installment of this series we looked at four reasons from gv$sql_shared_cursor view and explained the situations and criteria for which Oracle is forced to compile a new execution plan...
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby when to create the Standby using ACTIVE DA...
Troubleshooting is key part of any system when it is not functioning as expected, like wise when managing and working with GSM/GDS there are various commands available and various techniques in order ...
In this article we will see an interesting thing. When I was starting reading Oracle 12c Documentation I read that one of the enhancements of RMAN was Multi Section and another enhancement was the int...
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...
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 ...
