• 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,…

  • 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…