Manage APEX Service

Learn about managing APEX Service, including stopping, starting, and restarting.

Note:

Task instructions now use the Redwood Preview user interface. The Redwood Preview switch displays in the status bar at the bottom of the Browser window.

Parent topic: Manage Oracle APEX

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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  4. You can stop APEX Service in two ways:

    • On the APEX Instance Details page, click Actions and select Stop.

    • Navigate to the Autonomous Database Details page:

      • Under APEX instance information, click the Database NAME.

      • On the Autonomous Database details page, click More actions and select Stop.

  5. 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.

Parent topic: Manage APEX Service

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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  4. You can start APEX Service in two ways:

    • On the APEX Instance Details page, click Actions and select 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 page, click More Actions and select Start.

  5. 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.

Parent topic: Manage APEX Service

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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. Find and select your APEX Service.
    The APEX Instance Details page appears.
  4. You can restart APEX Service in two ways:

    • On the APEX Instance Details page, click Actions and select Restart.

    • Navigate to the Autonomous Database details page:

      • Under APEX Instance Information, click the Database NAME.

      • On the Autonomous Database details page, click the More Actions and select Restart.

  5. 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.

Parent topic: Manage APEX Service

About Auto Scaling

When you create an Autonomous Database instance, by default compute auto scaling is enabled and storage auto scaling is disabled. You can manage auto scaling from the Oracle Cloud Infrastructure Console to enable or disable compute auto scaling or storage auto scaling.

With compute auto scaling enabled the database can use up to three times more CPU and IO resources than specified by the number of ECPUs (OCPUs if your database uses OCPUs) as shown in the ECPU count or OCPU count field on the Oracle Cloud Infrastructure Console.

When you create an Autonomous Database instance, by default Storage auto scaling is disabled. When Storage auto scaling is enabled, the Autonomous Database can expand to use up to three times the reserved base storage, as specified by the storage shown in the Storage field on the Oracle Cloud Infrastructure Console. If you need additional storage, the database automatically uses the reserved storage without any manual intervention required.

To learn more, see Use Auto Scaling in Using Oracle Autonomous Database Serverless.

Tip:

View historical CPU utilization for a service on the CPU utilization (%) chart on the Database Monitor, Overview tab in Database Actions. To learn more, see Database Dashboard Page in Using Oracle Database Actions.

Parent topic: Manage APEX Service

Modify CPU Count, Storage Resources, or Auto Scaling

Scale your Autonomous Database on demand by modifying ECPU count (or OCPU count), storage, or manage auto scaling.

To scale your database, modify ECPU count (or OCPU count), storage, 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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  4. You can access the Scale dialog in two ways:

    • On the APEX Instance Details page:

      • On the APEX Instance Details page, click Actions and select Scale.

        The Scale dialog appears.

        Description of scale.png follows
        Description of the illustration scale.png

      • ECPU count - The number of ECPUs (or OCPUs if your service uses OCPUs) to enable. The default is no change.

      • Storage - Specify the amount of storage you wish to make available to your database. The default is no change.

      • Storage unit size - Specify the storage to allocate in storage size units (GB or TB).

      • Compute auto scaling - Enabling Compute auto scaling allows the system to use up to three times the number of ECPUs (OCPUs if your database uses OCPUs) for processing workload if required.

      • Storage auto scaling - Allows the system to expand up to three times the reserved storage.

      • Click Update.

    • Navigate to the Autonomous Database details page:

      • Under APEX instance information, click the Database NAME.

      • On the Autonomous Database details page, click More actions and select Manage resource allocation.

        The Manage resource allocation dialog appears.

      • ECPU count - The number of ECPUs (or OCPUs if your service uses OCPUs) to enable. The default is no change.

      • Compute auto scaling - Enabling Compute auto scaling allows the system to use up to three times the number of ECPUs (OCPUs if your database uses OCPUs) for processing workload if required.

      • Storage - Specify the amount of storage you wish to make available to your database. The default is no change.

      • Storage unit size - Specify the storage to allocate in storage size units (GB or TB).

      • Storage auto scaling - Allows the system to expand up to three times the reserved storage.

      • Allocated storage - Displays the current allocated storage.

      • Shrink - Shrinks storage manually. Use after deletion of a significant amount of data. See Shrink Storage in Using Oracle Autonomous Database Serverless.

      • Click Apply.

Changing ECPU count (OCPU count if your service uses OCPUs), Storage, or enabling or disabling auto scaling options, 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 ECPU count (or OCPU count), then Autonomous Database scales the number in use down to the ECPU count (or OCPU count) number.

See Also:

Use Auto Scaling in Using Oracle Autonomous Database Serverless.

Parent topic: Manage APEX Service

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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  4. You can terminate APEX Service in two ways:

    • On the APEX Instance Details page:

      • On the APEX Instance Details page, click Actions and 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 page, click More actions and select Terminate.

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

Parent topic: Manage APEX Service

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. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. 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 Actions menu (or Actions menu) and select Move resource.

    • On the APEX Instance Details page:

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

      • From Actions, select, select Move resource.

    The Move resource dialog appears.

  4. Choose a new compartment and click Move resource.

Parent topic: Manage APEX Service

Update to ECPU Billing Model for APEX Service

Learn about updating an existing APEX Service instance to the ECPU compute model.

APEX Service previously offered two compute models when you create a new instance: ECPU and OCPU. OCPU is a legacy billing metric and is no longer available when provisioning a new instance. OCPU will be retired for APEX Service at some point in the future.

Note:

If you update your instance to the ECPU compute model, you cannot revert back to the OCPU compute model. To learn more, see Compute Models in Autonomous Database and Update to ECPU Billing Model on Autonomous Database in Using Oracle Autonomous Database Serverless.

To update from a OCPU billing model to a ECPU billing model:

  1. Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
  2. Next to the Oracle Cloud logo, click the Navigation menu (Navigation menu) and select Developer Services and then APEX Instances.
  3. On the APEX Instances page, find and select your APEX Service.
    The APEX Instance Details page appears.
  4. Navigate to the Autonomous Database details page:
    1. Under APEX instance information, click the Database NAME.
      Autonomous Database Details page appears.
    2. Under Resource allocation, OCPU count, click Update to ECPU model.
  5. Follow the instructions in Update Billing Model Autonomous Database to ECPU Compute Model in Using Oracle Autonomous Database Serverless.

Parent topic: Manage APEX Service