My wife and I are foodies, and in addition to cooking and dining out, we enjoy watching some of the cooking competitions on TV. One of our favorite themes is when the celebrities are challenged to produce multiple dishes with the same ingredients.
Recently…
"I felt a great disturbance in the Force, as if millions of voices suddenly cried out in terror and were suddenly silenced=" - Obi Wan - Star Wars
if the lack of support for RAC in Oracle 19c is disturbing the Force in your environments, here…
What if you woke up one morning and found that you had a doppelganger who was enthusiastically running around pretending to be you, spending your hard-earned money and doing who knows what with your identity. It sounds like a nightmare, right? But this…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
We all remember the movie that came out years ago about a dinosaur theme park where you could see living dinosaurs on an island. Everything worked great until the “bad” guys stepped in and crashed everything causing havoc and of letting the dinos out…
Woohoo! Just got word that my boss approved my January vacation and now I’ll get the opportunity to check several items off my bucket list as I hop across country to the Quest Database Fed Forum in DC on February 20th.
On my First stop I will…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
When a large customer appreciation company needed to categorize their Oracle auditing data by region, SharePlex came to their rescue. They were already using SharePlex’s Change History feature to track the userid’s, timestamp, before and after data values…
A large educational Institution recently approached us with a problem. Their Student Information and Financial databases were in Oracle, and a data warehouse containing extracts from both of these used for decision making, including opening more sections…
A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their…
Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.
Sometimes it…
I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'
I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…
SharePlex peer-to-peer setup
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
When installing SharePlex one of the things you need to do is verify the installation is working by using the SharePlex test tables before using your own tables.
There are a couple of scripts you can run to do this but in the video I recorded I show you…
SharePlex has an interesting feature termed Auto-Add that allows objects to be brought into replication as and when they are created on the source. Essentially the ongoing replication creates the objects in the target database once they are created on…
When very large tables are out of sync on the target and Compare is not a suitable sync option, it requires a set of coordinated steps to bring them in sync with the source tables. This is especially true if the downtime on the source table is not acceptable…
When you’re up to your ears in a database upgrade project, like an upgrade to Oracle 12c, you begin to look forward to little things.
Like going a few hours with no system notifications or text messages from your DevOps team.
 |
|
|
Like buying…
If 40,000 tickets for a high-demand concert went on sale at noon today, Ticketmaster could accept all the orders and sell out the venue by 12:03 P.M.
That’s one smooth-running, high-availability box office.
I mentioned in my previous post that…
I’m sure Oracle DBAs everywhere are keeping their collective ears close to the ground waiting for the official announcement on 12cR2. We still, rightly or wrongly, have a habit of waiting for the 2nd release of Oracle versions, but that’s for another…
I remember as a young lad of 12 years of age writing letters to friends and family that I had grown up with. As I would finish the letter, I would jump on my bike and run to the local post office to purchase a stamp for the letter. I’m not going…
During October 2015, Oracle announced that the Extended Support Fee for Oracle Database 11g R2 will be waived until May 31, 2017. After this period, Extended Support for Oracle Database 11g R2 will be offered until December 2020.
A primary concern for…
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer…
My grandmother was the greatest. She was the iconic example of old world class and style… I never knew she was also a prophet.
As I was growing up, she would always take me aside and raising a finger crooked from age, she would point to me and…
“How can I cook when they’ve taken my kitchen away?”
Like the man in the photo, you may have to ask yourself that question now that Oracle Streams has been deprecated. If you depended on Oracle Streams for moving data in your database…
