4 Manage APEX Service

Stop, start, retart, or terminate APEX Service or manage CPU, storage resources, and auto scaling for an Autonomous Database instance on either the APEX Instances Details page or the Autonomous Database Details page.

Note:

Many of the controls described in this topic are also accessible from the Row menu on the APEX Instances page.

Topics:

Stop APEX Service

Stop APEX Service by stopping the underlying Autonomous Database instance.

You can stop APEX Service from either the APEX Instances Details page or the Autonomous Database Details page.

To stop APEX Service and the underlying Autonomous Database instance:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  5. You can stop APEX Service in two ways:
    • On the APEX Instance Details page, click Stop.

    • Navigate to the Autonomous Database Details page:

      • Under APEX Instance Information, click the Database name.

      • On the Autonomous Database Details, from the More Actions drop-down list, select Stop.

  6. Click Stop to confirm.

Note:

When an Autonomous Database instance is stopped:

  • Tools are no longer able to connect to a stopped instance.

  • Autonomous Database in-flight transactions and queries are stopped.

  • APEX Service CPU billing is halted.

Start APEX Service

Start APEX Service by starting the underlying Autonomous Database instance.

You can start APEX Service from either the APEX Instances Details page or the Autonomous Database Details page. Start only displays for a stopped instance.

To start APEX Service and the underlying Autonomous Database instance:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  5. You can start APEX Service in two ways:
    • On the APEX Instance Details page, click Start.

    • Navigate to the Autonomous Database Details page:

      • Under APEX Instance Information, click the Database name.

        The Autonomous Database Details page appears.

      • On the Autonomous Database Details, from the More Actions drop-down list, select Start.

  6. Click Start to confirm.

Note:

When an Autonomous Database instance is started, APEX Service CPU billing is initiated, billed by the second with a minimum usage period of one minute.

Restart APEX Service

Restart APEX Service by restarting the underlying Autonomous Database instance.

You can restart APEX Service from either the APEX Instances Details page or the Autonomous Database Details page.

To restart APEX Service and the underlying Autonomous Database instance:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  5. You can restart APEX Service in two ways:
    • On the APEX Instance Details page, click Restart.

    • Navigate to the Autonomous Database Details page:

      • Under APEX Instance Information, click the Database name.

      • On the Autonomous Database Details, from the More Actions drop-down list, select Restart.

  6. Click Restart to confirm.

Note:

When an Autonomous Database instance is restarted, APEX Service CPU billing is initiated, billed by the second with a minimum usage period of one minute.

About Auto Scaling

Auto scaling is enabled by default when you create an Autonomous Database instance or you can use Scale Up/Down on the Oracle Cloud Infrastructure console to enable or disable auto scaling.

With auto scaling enabled, the database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. When auto scaling is enabled and your workload requires additional CPU and IO resources, the database automatically uses the resources without any manual intervention required.

To see the average number of OCPUs used during an hour, use the "Number of OCPUs allocated" graph on the Overview page on the Autonomous Database service console. Enabling auto scaling does not change the concurrency and parallelism settings for the predefined services.

Modify CPU Count, Storage Resources, or Auto Scaling

Scale your Autonomous Database on demand by modifying CPU cores or storage (TB), or manage auto scaling.

To scale your database, modfy CPU cores or storage (TB), or enable/disable auto scaling:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  5. You can access the Scale dialog in two ways:
    • On the APEX Instance Details page:

      • From the More Actions drop-down list, select Scale.

        The Scale dialog appears.

        Description of scale.png follows
        Description of the illustration scale.png
      • OCPU Count - Click the up or down arrow to select a value. The default is no change.

      • Storage (TB) - Click the up or down arrow to select a value. The default is no change.

      • To change auto scaling, enable or disable Auto Scaling.

      • Click Save Changes.

    • Navigate to the Autonomous Database Details page:

      • Under APEX Instance Information, click the Database name.

      • On the Autonomous Database Details click Scale Up/Down.

        The Scale Up/Down dialog appears.

        Description of scale_up_down.png follows
        Description of the illustration scale_up_down.png
      • OCPU count - Click the up or down arrow to select a value. The default is no change.

      • Storage (TB) - Click the up or down arrow to select a value. The default is no change.

      • To change auto scaling, enable or disable Auto Scaling.

      • Click Update.

Changing OCPU Count, Storage, or enabling or disabling Auto Scaling, changes the Lifecycle State to Scaling in Progress. After the Lifecycle State changes to Available the changes apply immediately.

Note:

If auto scaling is disabled while more CPUs are in use than the specified CPU Core Count, then Autonomous Database scales the number of CPU cores in use down to the CPU Core Count number.

Terminate APEX Service

Terminate APEX Service by terminating the underlying Autonomous Database instance.

You can terminate APEX Service from either the APEX Instances Details page or the Autonomous Database Details page:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  5. You can terminate APEX Service in two ways:
    • On the APEX Instance Details page:

      • From the More Actions drop-down list, select, select Terminate.

      • On the Terminate APEX Instance page, enter the APEX instance name to confirm the termination and click Terminate.

    • Navigate to the Autonomous Database Details page:

      • Under APEX Instance Information, click the Database name.

      • On the Autonomous Database Details, from the More Actions drop-down list, select Terminate.

      • On the Terminate Autonomous Database page, enter the database name to confirm the termination and click Terminate Autonomous Database.

Move Resource to a Different Compartment

Move an APEX Service to a different compartment from either the APEX Instances page or APEX Instance Details page.

Compartments help you organize resources to make it easier to control access to them. Moving an APEX Service instance to another compartment also moves the underlying database resource. See Understanding Compartments for information on using and managing compartments.

Note:

To move a database you must have the right to manage Autonomous Databases in the database's current compartment and in the compartment you are moving it to.

As soon as you move a database to a different compartment, the policies that govern the new compartment apply immediately and affect access to the database. Therefore, your access to the database may change, depending on the policies governing your Oracle Cloud user account's access to resources.

To move an APEX Service to a different compartment:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. In the upper left corner next to the Oracle Cloud logo, click the Navigation Icon.
  3. From the Oracle Cloud Infrastructure left navigation list, find Database Related Services and select APEX Application Development and then APEX Instances.
  4. You can move a resource to a different compartment in two ways:
    • On the APEX Instances page:

      • Find your APEX Service instance.

      • Click the three dots Row menu (or Row menu) on the right side page and select Move Resource.

    • On the APEX Instance Details page:

      • On the APEX Instances page, find and select your APEX Service.

      • From the More Actions drop-down list, select, select Move Resource.

    The Move Resource to a Different Compartment dialog appears.

  5. Choose a new compartment and click Move Resource.

Learn More About Autonomous Database Lifecycle Operations

Learn more about Autonomous Database instance lifecycle operations in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

See Part II: Managing Autonomous Database in Using Oracle Autonomous Database on Shared Exadata Infrastructure