Posts by Marc Fielding
After observing CPU core sharing with Amazon Web Services EC2, I thought it would be interesting to see if Microsoft Azure platform exhibits the same behavior. Signing up for Azure’s 30-day trial gives $200 in credit to use over the next 30-day period: more than enough for this kind of testing. Creating a new virtual…
I’ve been doing some testing to clarify what a vCPU in Amazon Web Services actually is. Over the course of the testing, I experienced inconsistent results on a 2-thread test on a 4-vCPU m3.xlarge system, due to the mislabeling of the vCPUs as independent single-core processors by the Linux kernel. This issue manifests itself in…
The definition of a vCPU in Amazon Web Services is a bit unclear. We run some tests to see how much CPU performance we actually get, and discover some unexpected side effects from AWS’s implementation.
Yes you can still disable triggers per-session in Oracle 18.104.22.168, but you have to have a GoldenGate license, set the
enable_goldengate_replication parameter, use a program name that starts with
replicat, and set your module to
I’ve spent the better part of the day troubleshooting an issue with Oracle’s Auto Service Request (ASR) and wanted to share my results in case if saves someone else some effort.
This is part 3 of a multipart series of getting oracle RAC running on a cloud environment. In part 1, we set up a NFS server for shared storage. In part 2, we set up OS components for each RAC server. Now we finish up the OS configuration and move to Oracle grid infrastructure.
In part 1 of this series, we talked about some of the challenges of setting up Oracle RAC on a public cloud provider, and went on to order some VMs from provider Gandi, and finally configuring a NFS server for shared storage. In this post, we move on to configuring the rac servers themselves, rac01 and rac02.
I’ve been working on moving a lot of the testing and R&D work I do away from local virtual machines and onto cloud environments, for a few reasons: I can avoid carrying around a laptop all the time, and rather log onto the cloud wherever I happen to be It’s easy to scale down and…
I was recently playing with an Oracle XE database. The main benefit of Oracle XE is that it can be used free of charge.
I was recently looking at an issue where a large database server was running out of temp space. The issue had happened in the past, so the goal was to identify what had been causing the system to run out of temp. Although ORA-1555 messages will appear in the database alert log (with query text) when a query runs out of temporary space, they only talk about the query that was “unlucky” enough to be attempting to get space when the tablespace was full, not who was using the temp space.