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...
How do you think companies feel about returned merchandise or a cancellation? I worked with PayPal for a period of time to help them decrease churn (their equivalent of a service cancellation). Trust...
That’s how a lot of my conversations begin when I talk to people about Toad for SQL Server. Most database pros understand why we have Toad solutions for databases like Oracle, DB2 and SAP. However, ...
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...
Lessons Learned You may have heard Einstein's definition of insanity: doing the same thing over and over again and expecting different results. I'm constantly surprised at how often companies don't ta...
Toad Data Point version 4.0 is being released today! With each release of Toad Data Point we are focusing on adding enhancements requested by users which make connecting, querying and data prep easie...
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...
