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 […]
I have an AdminManaged Database in my (2node) RAC Cluster.
How do I convert it to PolicyManaged ?
(Yes, let me admit : It makes no sense to have PolicyManaged on a 2node Cluster. But since I can't create an 8 or 16 node Cluster (with multiple databases to boot ?!), let me demonstrate with a 2node Cluster. The principle remains the same).
First, I show the configuration of the database in the Cluster :
[oracle@collabn1 ~]$ srvctl status database -d RAC
I published a blog post called “
href="https://www.pythian.com/blog/investigating-io-performance-on-amazon-rds-for-oracle/" target="_blank">Investigating IO Performance on Amazon RDS for Oracle” recently, and soon after posting it I received several questions asking if IO worked the same way on EC2 instances. My immediate though was it did, mostly because RDS for Oracle is basically an EC2 instance with Oracle Database on top of it, where the configuration is fully managed by Amazon.