Many companies are cutting costs and gaining a major boost in scalability, agility and innovation potential by moving their enterprise applications to the cloud. Amazon Web Services (AWS) has proved to be an especially popular platform because it supports pretty much any use case you might imagine. This flexibility may be why it has more than a million active customers.
I was reminded recently of a project I did during a DevDays week at WebAssign in 2014. The engineering department wanted to move a large dataset into MongoDB, and my DevDays experiment was to demonstrate the Tungsten Replicator’s role in translating data from MySQL to MongoDB.
Hot cloning PDBs is new in 12.2, so you don’t have to put the source PDB into READ ONLY mode before the cloning if you have it in local undo mode. I suppose shared undo mode will become very unpopular. Another 12.2 New Feature is the option to clone a PDB that can be refreshed from the source PDB. I will show both features with this article, but you may of course do hot cloning without a later refresh.
A relatively common on the forums is regarding the escaping of special characters in reports, but it seems the developer isn't always sure what is actually happening and how to how to search for it.
It seems I've had this on my "to blog" list since April 2015, but now that 5.1 has been released, it seems more people are coming out to leave 4.x can't work out where the Standard Report Column option is.
Forum questions can sometimes cause distractions for me because they peak my interest at times, especially when I see someone say “Extended Event (XE) session is not showing the expensive query”. Extended Events are just…
3 months ago I had never been in Dubai and now here I found myself headed back there. In Gitex, I mentioned the mass of chaos the last time I was here. This time felt more orderly and purposeful. I was here for a Dbvisit Partners meeting and then followed up on various meetings that I had at Gitex the previous month. Monday morning was a fantastic start to the week.
After having looked at the performance consistency provided by the Oracle Database Cloud offering in the previous series, I'll focus here on the raw performance figures I've measured during my tests, starting with the CPU related performance findings.
One of the first surprises is related to the fact that Oracle uses a unit called "OCPU" to specify the CPU capacity provided, which is explained here:
Are you wondering if you should name your Oracle database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article. Why Do We Need SQL Table Naming Conventions? You might be wondering why we need conventions or […]
By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism, identify if there are any missing prequisites commands like “add trandata” on the source. When this happens you need to troubleshoot the issue and correct it before the […]