• Database,  OCI,  PaaS

    Automatic (Scheduled) Scaling for ADW and ATP

    Last week I released a script that allows you to schedule the scaling of an Oracle Database running on the baremetal cloud instances. That script was designed to run inside the actual Database instance. The new Oracle Autonomous services do not allow you to do this, as these are fully managed platforms by Oracle, so you do not have access to the console to run script. So I made a new script for Scheduled Auto Scaling for the Autonomous Data Warehouse and Autonomous Transaction Processing Services. Both services work on a fixed per OCU per Hour price model. So the more more efficient you can scale this up and down,…

  • General Info,  OCI

    Oracle Cloud Infrastructure Architect Associate Exam (1Z0-932)

    Whoop whoop! I just passed the OCI Associate Exam. While I have reasonable hands-on experience with OCI, for preparation  I read the study guide and did the test exam. You can find the preparation documents here: https://education.oracle.com/product/pexam_1Z0-932  I guess I had 57 correct and 13 not correct 🙁 . Currently the study guide mainly covers the Networking, Compute and Database parts, but it does not cover anything about the Data Transfer Service or File Storage Service. So I highly recommend you read up on those as well! To prep for the exam, I really recommend hands-on experience. I recommend you at least tried the following: Create Compute and Database Instances…

  • Database,  OCI

    Automatic (Scheduled) Scaling of your Oracle Database on OCI

    While running Database servers cost money in power and cooling, a much bigger cost is the licensing cost of the Oracle Database software. In your own environment this might be considered a fixed cost, in the Oracle Cloud this does not have to be the case at all. When you spin up a bare-metal Database server on OCI, it can start with 2 cores (4 vCPUs). This server is JUST-FOR-YOU, so you will not share this physical server with anyone else. The actual server has 36 (X5 model) or 52 (X7 model) actual cores. You can scale up and down the number of cores, this will enable / disable the…