This article is focused on how to do troubleshoot the Logical standby database and monitoring the logical standby database apply, In detail we will go through how the SQL Apply process actually works ...
A Note About Notes As a business analyst, I'm sure you spend a lot of time in meetings, and I'm sure you take a lot of notes. But are you getting the most out of your notes? That depends on what you d...
Hi, We continue this series of blogs on New Features for Developers with some updated syntax to external tables. External tables are great and they have been around for a while. They are basically a ...
We’ve posted recently about database developers feeling left out of agile processes. You may wonder how application developers can have it so easy – scrums, sprints and automation – to deploy updates ...
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...
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...
In database replication, “immediately” never feels quite fast enough for your users, does it? “We replicate transactions from production databases in real time,” you tell them. “You’ll see the change ...
